MMBasic for Windows - betas

Author Message
Michal
Senior Member

Joined: 02/02/2022
Location: Poland
Posts: 123
Posted: 11:30am 04 Mar 2022      

  Mixtel90 said  Ah, but you can't load data to a device with no storage medium, say a Micromite or a PicoMite (when used without a SDcard). The data has to be inline within the program - like a CSUB or an embedded font - or use DATA statements. SQLite would be of no use unless you used it on embedded data, neither would include. VAR SAVE / VAR RESTORE are ok for keeping data between runs, but store data on the local device, not as part of the program.
.


Since you can load from *.inc and other files, you can also load from *.db3 files.
You can load a comma-separated field with a string of words, and then break it apart like normal DATE.

In Pascal it looks like this:
I.AsString:='5';
ZQuery1.SQL.Text:='SELECT companyname FROM suppliers where supplierid='+I;
ZQuery1.Open;
Data1.AsString:=ZQuery1.Fields[0].Value;

in Data1- Ala,Ola,Ula,Ewa

by changing supplierid = 2 or 5 or 200 you decide which date you get.

Michal
Edited 2022-03-04 21:38 by Michal