Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert-Update-Delete to SQLCE from VFP
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server CE
Application:
Desktop
Miscellaneous
Thread ID:
01438635
Message ID:
01438683
Views:
21
>>>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform