Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert-Update-Delete to SQLCE from VFP
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server CE
Application:
Desktop
Divers
Thread ID:
01438635
Message ID:
01438683
Vues:
22
>>>oops,
>>>The second parameter in CursorFill() should be logical value:
>>>Try:
>>>
>>>....
>>>If !oCA.CursorFill(.f.,.f.,-1,oComm)
>>>....
>>>
>>
>>and now :(
>>property updateNamelist has invalid value
>>
>>table structure like below
>>ckodu nvarchar(16) NOT NULL ,Unique Yes,Pkey No
>>cadi nvarchar(30) NULL ,Unique No,Pkey No
>>myguid nvarchar(38) NOT NULL Unique Yes , Pkey Yes , DEFAULT newid()
>
>
>:-)
>That's what happens when you write directly in the forum :-)
>But I have no CE installed here to testd it:
>try this:
>
>.....
>   lcStr2 = lcStr2 + laFlds[m.i,1] +  " CARI."+laFlds[m.i,1]+"," && There should be SPACE before CARI
>.....
>
Yes now its working :)
is it enough like below commands
* Add user code here.
* Note: cursors created by CursorAdapter object are closed when object is released.
cSQL = "insert into cari(ckodu,cadi) values('Boris','Soykan')"
oComm.Execute(m.cSQL)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform