LiveCode Forums

I can't be more specific. NO ERROR MESSAGE. Original did not populate and produced no error message. When I found into and after, worked fine.

this is what worked put "INSERT into instrument_details VALUES ('EAGLE', 'APU', 'FI', '10V/100mA', '10', '-10', '0.1', '0.00000305', '0.0000125', '0.001', '0.0000004', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0','0');" into tSQL put "INSERT into instrument_details VALUE...

Actually I have and did and do peruse. The format that I got was from doing so. I understand that it might not be best practice, but since this is ALL that I have found, I am not sure what best practice is. Even the SQL.org site says to do it this way.

put "CREATE TABLE users(mgfcode text, model text, mode text(2))" into tSQL put "INSERT INTO 'users' values( 'EAGLE', 'APU', 'FI')" into tSQL can someone tell me why the create statement seems to work and the insert new data into the table does not work?? that is I get no compilation or run errors an...

I have townsends example and have a couple of newbie questions.

where is all the code for the handler routines, for example, doConnect.

I can't find it in the stack and know it should be there.

thanks

thanks!!

does anyone have an example (simple) that works?
I can't anything to work. the database always is 0 kilobytes. the demo off of runrev does not work well and can't figure out where they are getting the data to feed to it.
thanks in advance

Klaus, In the example given for the SQLite, they say that only integer text and boolean are available. and from sqllite they have Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes: NULL. The value is a NULL value. INTEGER. The va...

I have an excel spreadsheet with vba that I want to convert. It is about 1300 lines of data using the database feature of excel to get my answers. It also has floating point numbers ranging from 1e3 to 1e-22. when i convert should I use sqlite or a datagrid? and if I use sqlite how do I handle the f...

My reading of the SQL example seems to say that only integer, text and boolean are allowed.
If true, how does one handle floats?