You can also execute the two commands to USE the table first and then REPLACE, but it must be wrapped as a single call, so you need to put these two commands in an EXECSCRIPT(+CHR(13)+). It's correct sql syntax to write field name only, but for some reason here errors with a syntax error. So qac.value will address the value field of the qac.ref table, if vfp is able to load it.Īlso as Rivandra Patil found out, Value alone gives a syntax error, as it's also a vfp key word, most probably. ref set qac.VALUE = 100 where no = 'SR'Īs with DBFs, where the file name is tablename.dbf, but loaded as an alias "tablename" the file qac.ref is loaded as alias qac only. TutorialFoxpro PemrogramanFoxpro MembuatFormVideo ini membahas mengenai cara membuat form dan memberikan action pada button untuk menampilkan apa yang d. If vfp can read the table, then it would be correct and needed to write update qac. So what error does the statement give you? VFP can cope with some dbase formats, some foxbase format and it's own dbf formats, and maybe also partially with clipper dbfs, but not all. ![]() As you say it was written in clipper, then VFP or the Foxpro OleDBProvider may no be able to work on that table, if it's a clipper table and not a 2.6 dbf
0 Comments
Leave a Reply. |