Search Forum Home   Visual FoxPro  Baze de date, tabele, view-uri si indecsi  Creare view pro...  Creare view programatic    5/13/2011 12:04:23 PM Marian Dobre 398 posts Creare view programatic  (N/A) Exista posibilitatea ca prin comanda create sql view sa se poata bifa check box-ul send SQL updates din tab-ul Update Criteria? Orice putere omeneasca este un compus de rabdare si de timp. Balzac  5/13/2011 12:44:54 PM Doru Constantin 321 posts Re: Creare view programatic  (N/A) CursorSetProp("SendUpdates", .T., cCursorul)  5/13/2011 12:45:01 PM Doru Constantin 321 posts Re: Creare view programatic  (N/A)  .  5/13/2011 1:01:32 PM Grigore Dolghin 3590 posts www.class-software.eu Re: Creare view programatic  (N/A) Nu direct, dar poti sa executi DBSETPROP() dupa aceea. Grigore Dolghin Visual FoxPro MVP 2006 - 2010 Class Software My blog  5/16/2011 11:04:20 AM Marian Dobre 398 posts Re: Creare view programatic  (N/A) Multumesc pentru ajutor. Am reusit cu ceva de genul urmator: Create Database TesteVfp Create Table TestView (idTestView i Autoinc Nextvalue 1 Step 1 Primary Key, ;     nume c(25)) Create Sql View viwTestView As Select TestView.idTestView, TestView.nume;     FROM ;     TesteVfp!TestView ;     ORDER By TestView.nume =DBSetProp("viwTestView","View","SendUpdates",.T.)      =DBSetProp("viwTestView","View","BatchUpdateCount",1) =DBSetProp("viwTestView","View","CompareMemo",.T.)     && Merge si cu = DBSetProp("viwTestView","View","FetchAsNeeded",.F.)    && Merge si fara = DBSetProp("viwTestView","View","FetchMemo",.T.) DBSetProp("viwTestView","View","FetchSize",100) DBSetProp("viwTestView","View","MaxRecords",-1) DBSetProp("viwTestView","View","Prepared",.F.) DBSetProp("viwTestView","View","UpdateType",1) DBSetProp("viwTestView","View","UseMemoSize",255) DBSetProp("viwTestView","View","Tables","testevfp!testview") DBSetProp("viwTestView","View","WhereType",3) =DBSetProp("viwTestView.idTestView","Field","DataType","I") =DBSetProp("viwTestView.idTestView","Field","UpdateName","testevfp!testview.idtestviev") =DBSetProp("viwTestView.idTestView","Field","KeyField",.T.) =DBSetProp("viwTestView.idTestView","Field","Updatable",.F.) DBSetProp("viwTestView.nume","Field","DataType","C(25)") DBSetProp("viwTestView.nume","Field","UpdateName","testevfp!testview.nume") DBSetProp("viwTestView.nume","Field","KeyField",.F.) DBSetProp("viwTestView.nume","Field","Updatable",.T.) Close Tables All CursorSetProp("Buffering",5,0) Use viwTestView In 0 Select viwTestView Insert Into viwTestView (nume) Values ("Nume Test") Insert Into viwTestView (nume) Values ("Alt Nume de Test") Insert Into viwTestView (nume) Values ("Din nou un Nume de Test") Browse Noed Tableupdate(.T.,.T.,"viwTestView") Requery("viwTestView") Browse Noed Orice putere omeneasca este un compus de rabdare si de timp. Balzac  Page 1 of 1   Visual FoxPro  Baze de date, tabele, view-uri si indecsi  Creare view pro... Flat View Tree View Oldest To Newest Newest To Oldest