StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I use the VFP OleDB regularly, and have no problem doing ANY inserts, updates, deletes, selects.... One thing to note. Your connection string can either point to a directory where the tables are located. In addition, the database can be included if a specific .DBC is associated with the tables in question.</p> <p>When running a query, insert, update or delete, you do not need to qualify the database such as </p> <p>DEN....produtos (which I assume is meant to be Denny_db.Produtos -- thus indicating Database.Table to run query against). Don't do that... the database is open and "visible" from the connection.... you should just be able to do....</p> <pre><code>Update Produtos set x = 1 where something = whatever or insert into Produtos (fld1, fld2, fld3) values ( something1, another2, last3) </code></pre> <p>Another thing about VFP, when the table is associated with a given database, as soon as it is opened, if the corresponding database is NOT opened, it will be FORCED open to utilize any triggers and such. So you COULD simplify your connection to just point to the path and let the rest of the stuff just WORK for you.</p> <p>Another note.... if you have a directory structure that has paths under it with data in other locations, such as </p> <pre><code>C:\SomeFolder\MainDataPath\ C:\SomeFolder\MainDataPath\SomeArchives\ C:\SomeFolder\MainDataPath\OtherFolder\ </code></pre> <p>and make your connection to just the <code>"C:\SomeFolder\MainDataPath\"</code> location, your queries can use relative path to get at data inside the other locations such as </p> <pre><code>select whatever from SomeRootTable SRT join SomeArchives\SubFolderTable SFT on SRT.KeyID = SFT.LinkKeyID </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload