3/31/2024 0 Comments Xojo using classes![]() ![]() method CreateParam(name as string, ParamType as Integer, DirType as Integer=0) as SQLParamMBS.method Constructor(connection as SQLConnectionMBS, SQLCommand as String, CommandType as Integer = 0). ![]() shared property CommandCount as Integer.property Option(name as string) as string.property Connection as SQLConnectionMBS.event Trace(traceInfo as Integer, SQL as string).When using RecordSet, the values are read via Value() functions automatically. When you call Field() you always get last row, but to read from cached result set, please use Value() function. After this you can walk over the recordset and use FetchPos, FetchFirst, FetchLast, FetchPrev and FetchNext to locate the rows you need. The plugin will than fetch all records and store them in memory. To enable you can call SQLCommandMBS.Cache or use the Option("AutoCache") = "true" on either command or connection or database objects. The plugin can cache the recordset locally. connection can also be specified in SACommand constructorĬmd.setCommandText( "Create table test_tbl(fid integer, fvarchar20 varchar(20), fblob blob)")Ĭmd.setCommandText( "Insert into test_tbl(fid, fvarchar20) values (1, 'Some string (1)')") connect to database (mySQL in our example)Ĭon.Connect( "root", "", SQLConnectionMBS.kMySQLClient) Con = new SQLConnectionMBS // connection objectĬmd = new SQLCommandMBS // create command objectĬon.SetFileOption con.kOptionLibraryMySQL, ( "libmysqlclient.dylib") ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |