Search found 198 matches

by chipsm
Sun Oct 04, 2015 12:03 am
Forum: SoCal LiveCode Group
Topic: October 1 meeting, Pasadena
Replies: 8
Views: 4400

Re: October 1 meeting, Pasadena

Thanks Jim.
This is a great suggestion.
I will keep everyone posted on how things are going.
I already tried the "filter" suggestion and it was GREAT!
by chipsm
Fri Oct 02, 2015 2:44 pm
Forum: SoCal LiveCode Group
Topic: October 1 meeting, Pasadena
Replies: 8
Views: 4400

Re: October 1 meeting, Pasadena

Paul,

Thanks for your work on the document. I do appreciate the work and effort as I am sure many others also appreciate you efforts.
by chipsm
Fri Oct 02, 2015 2:42 pm
Forum: SoCal LiveCode Group
Topic: October 1 meeting, Pasadena
Replies: 8
Views: 4400

Re: October 1 meeting, Pasadena

Thanks for the link to the thread, I will be reviewing it. I would like to thank all of the members for their input to my code. I actually tried one suggestion out using the "filter" command and it worked well. The next try will be the "replace" command. I will be placing a lot of time capturing rou...
by chipsm
Wed Sep 30, 2015 3:48 am
Forum: SoCal LiveCode Group
Topic: October 1 meeting, Pasadena
Replies: 8
Views: 4400

October 1 meeting, Pasadena

Are we having any special visitors or demos for this meeting?
by chipsm
Sun Jul 05, 2015 6:19 pm
Forum: Talking LiveCode
Topic: Password protected stack
Replies: 8
Views: 3037

Re: Password protected stack

Richard, Password encryption for Livecode edits can only be done on the Stack Script level? Or should I say that encryption defaults to the stack level. I was wondering if encryption could be just done on object's script only, although I haven't truly thought of why at this time. Just my mind explor...
by chipsm
Mon Jun 29, 2015 12:35 am
Forum: SoCal LiveCode Group
Topic: Meeting: July 2, Pasadena
Replies: 2
Views: 2457

Re: Meeting: July 2, Pasadena

I'll be there!
by chipsm
Thu Jun 18, 2015 11:48 pm
Forum: Databases
Topic: revDatabaseTableNames
Replies: 4
Views: 1597

Re: revDatabaseTableNames

The Tables are what I have been given and I have no control over them. I think it was done this way in order to make them proprietary and difficult for other people to use them. Hence, the spaces in the table names.
by chipsm
Thu Jun 18, 2015 6:12 pm
Forum: Databases
Topic: revDatabaseTableNames
Replies: 4
Views: 1597

Re: revDatabaseTableNames

Klaus,
I am checking that out and will post a response once I have an answer.
by chipsm
Thu Jun 18, 2015 5:41 pm
Forum: Databases
Topic: revDatabaseTableNames
Replies: 4
Views: 1597

revDatabaseTableNames

I am using this code ("revDatabaseTableNames") to count the number of tables in my database. I am putting the results into a temporary field. This actually puts the list of table names into the temp variable.I then do a count of the records. I have verified the wrong count using a database tool "Nav...
by chipsm
Wed Jun 17, 2015 2:25 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 5551

Re: DataBase Cursor

Hi Max,
I tried many iterations of quotes but I don't remember just using the keyword quote. I used "put quote &" and that didn't work.
I'll try that later.
Thanks.
by chipsm
Tue Jun 16, 2015 10:49 pm
Forum: Databases
Topic: Inserting string with special characters into MySQL field
Replies: 24
Views: 12138

Re: Inserting string with special characters into MySQL fiel

I don't know if your problem was solved. I had problems opening a table that had spaces in its name. I solved the problem by using the tick mark, instead of quotes, to surround the string. The tick mark is located on your keyboard just left of the #1 key. see my posting below. http://forums.livecode...
by chipsm
Tue Jun 16, 2015 4:02 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 5551

Re: DataBase Cursor

Mikey and all who need it.
Thanks to Mikey for helping me.
During a search I found the answer.
Use the tick symbols which you can usually find on your keyboard to the left from digit 1.
This Works.
by chipsm
Tue Jun 16, 2015 3:56 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 5551

Re: DataBase Cursor

Mikey,
again...thanks for your help.
by chipsm
Tue Jun 16, 2015 3:20 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 5551

Re: DataBase Cursor

Mikey, I don't have Valentina. The 465 is part of the table name. I actually made a copy of the table without the spaces and the code works (this is before the square brackets). This is how I found out about the spaces in the Table Name and spaces. So, the square brackets don't seem to be working fo...
by chipsm
Tue Jun 16, 2015 3:05 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 5551

Re: DataBase Cursor

Mikey,
This is the code that I used and the same problem is still existing.

put "SELECT * FROM [465 halstead coppercube_10100_tl1]" into tSQL
put revDataFromQuery(tab,return,lDatabaseID,tSQL) into tRecords
put tRecords into field "Field2"

What am I doing wrong?

Go to advanced search