Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odbc MySQL
Message
De
20/02/2004 11:32:11
 
 
À
20/02/2004 09:35:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00879178
Message ID:
00879285
Vues:
19
>Hello,
>I have the next code :
>nhandle = sqlconnect('Estadis_ds','root','')
>= sqlsetprop(nHandle, 'Transactions', 2) && Manual transactions
>select 1
>use hesta alias esta
>select esta
>go top
>do while .not. eof()

sqlexec(nhandle, "insert into tabla1 (fieldname1, fieldname2) values
(?campo1, ?campo2) ")
> sqlcommit(nhandle)
> select esta
> skip
>enddo
>select 1
>use
>sqldisconnect(nhandle)
>The problem is :
try this - if its just one field [campo1] then change to be (fieldname1) in the string ..

its ...
sqlexec(handle, "[string]","[name of resultant cursor]")

you just had some typo's there with building your nhandle thingie after you set it ...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform