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 ...

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 ...

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 ...

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 ...

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