Search found 190 matches

by chipsm
Thu Jun 18, 2015 5:41 pm
Forum: Databases
Topic: revDatabaseTableNames
Replies: 4
Views: 1252

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: 4494

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: 9029

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: 4494

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: 4494

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: 4494

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: 4494

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?
by chipsm
Tue Jun 16, 2015 2:56 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 4494

Re: DataBase Cursor

Thanks. I will try it immediately.
by chipsm
Tue Jun 16, 2015 2:37 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 4494

Re: DataBase Cursor

Please elaborate!
by chipsm
Tue Jun 16, 2015 1:23 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 4494

Re: DataBase Cursor

Thanks Max, I actually found the problem. I was beating my head against a wall that was somewhat impenetrable. I found out that LiveCode cannot process tableNames that have spaces in them. It throws a "revdberr" message. Does anyone have a work around for this problem? Unfortunately I am not in cont...
by chipsm
Mon Jun 15, 2015 9:10 pm
Forum: Databases
Topic: DataBase Cursor
Replies: 25
Views: 4494

DataBase Cursor

I have a routine where I open a database and read all of the table names into a field.
I use this data to select a table that I would like to do a query on. I cannot query the tables. is this because the pointer of cursor of the database is at the bottom and needs to be reset?
by chipsm
Fri May 08, 2015 5:02 pm
Forum: SoCal LiveCode Group
Topic: Meeting: May 7, Pasadena
Replies: 2
Views: 1976

Re: Meeting: May 7, Pasadena Follow-up

We had a good meeting last night. There were a lot of questions on learning resources and I have found a few that I think are good. Here are the links that I have explored so far: http://livecode1001.blogspot.com/ http://livecode.byu.edu/ They both have a lot of contributions and applications along ...
by chipsm
Mon Feb 23, 2015 9:28 pm
Forum: Talking LiveCode
Topic: A Scrum Board written in LiveCode!
Replies: 25
Views: 2668

Re: A Scrum Board written in LiveCode!

I wanted to make the SCRUM Board to be made of multiple cards. That way if I drag a Note across to another portion of the SCRUM board I could change colors as a reacation of moving the the Note to the To Do Area for instance.
by chipsm
Mon Feb 23, 2015 9:21 pm
Forum: Talking LiveCode
Topic: A Scrum Board written in LiveCode!
Replies: 25
Views: 2668

Re: A Scrum Board written in LiveCode!

This is a general question.
Can multiple cards be placed on another card?
by chipsm
Mon Feb 23, 2015 3:38 pm
Forum: Talking LiveCode
Topic: A Scrum Board written in LiveCode!
Replies: 25
Views: 2668

Re: A Scrum Board written in LiveCode!

Keith, I like your SCRUM Board. It is ideas like this that sell LiveCode to me. I is my hope that ideas for projects like this would be the basis for a complete sample project that the LiveCode team would be willing to deliver to the "Create it with LiveCode" team and participants. I could foresee a...

Go to advanced search