Sql Central.
Tools - dba, sql. Sql central(Add table Tables) .
, , Test_lb fam, name_, sndname, street.
FOXPRO
DB.
SQLCONNECT(< .>, < >,<>)
:
SQLCONNECT() 0, . . SQLCONNECT() 1 .
:
User_Name=dba
User_Password=sql
E1=SQLCONNECT('SQL Anywhere 5.0 Sample',User_Name,User_Password)
SQLEXEC(< >, <Sql >, < ()>)
:
SQLEXEC() . SQLEXEC() 0 , 1 . SQLEXEC() 1 .
:
< > SQLCONNECT().
<SQL > SQL .
< > e Visual FoxPro . , Visual FoxPro SQLRESULT.
=SQLDISCONNECT(< >)
. .
:
E1=SQLCONNECT('SQL Anywhere 5.0 Sample',User_Name,User_Password)
If e1 > 0
b1=SQLEXEC(e1,"select * from dba.my_first_table ",'my_curs')
b1=SQLEXEC(e1,"UPDATE dba.my_first_table SET street=")
Else
MessageBox(' !',48,' ')
EndIf
rez=SQLDISCONNECT(e1)
:
- dbinit;
- ODBC;
- Sql Central;
- INSERT UPDATE FOXPRO.
- Select .
- , , .
:
- 1 -
- - - - .
- .