Navigation:  Работа с внешней Базой Данных (SQL) >

Пример работы с внешней БД

Previous pageReturn to chapter overviewNext page

sql_connect Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\test.mdb;Jet OLEDB:Database Password=;

log [:SQLERRORCODE:] [:SQLERROR:]

 

sql_execute select * from tbl order by name;

log [:SQLERRORCODE:] [:SQLERROR:]

log records: [:SQL.RECORDS:]

 

sql_recordset get 1

log [:SQL.FIELD1:] [:SQL.FIELD2:]

 

sql_recordset get 2

log [:SQL.FIELD1:] [:SQL.FIELD2:]

 

sql_recordset get 3

log [:SQL.FIELD1:] [:SQL.FIELD2:]

 

sql_disconnect