This is getting more complex than what I had hoped for. I understand how the 'project' command extracts the fields that I want to work with and creates a new (R:Base) table containing the fields & records that apply.
I was hoping to work with the MS SQL tables directly. Preferably by the use of forms and WHERE & ORDER BY phrases. I believe I understand that SQL INSERT will append the table with the updated records, but I am not sure how I keep the non-projected fields, unless I project all the fields. Do I make sure I only add the changed records? If so, how do I do that? I'm assuming that the SSQL INSERT command adds the rows from the projected table to the original table, but then I have two similar rows and need to remove the original row. What is the technique to issue the DELETE command in such a way that I delete the original row, but not the just appended row? I'm sure it is clear that I am not sure of what I'm doing. Thanks for any clarification that can be offered. Hans v.8 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gunnar Ekblad Sent: Tuesday, November 04, 2008 11:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SV: I/O problems Hans I have had that message in the past. I never understood it! But it is certainty not lack of disk space. My own workaround is: I never touch a non r:base sconnected table directly. I allways project a temp table from the attached table. I do always use the that temp table for my views forms report, then I use SSQL UPDATE SSQL INSERT SSQL DELETE To transfer my updates to the origin DB in the foreign DB. This is not maybe an answer to your question but it might bee a workaround Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För Hans Manhave/Jackson-Lloyd Skickat: den 3 november 2008 23:37 Till: RBASE-L Mailing List Ämne: [RBASE-L] - I/O problems What would be a reason for getting: -ERROR- I/O problems - Check for a full disk. (2009) After having attached a MS SQL table and the table being displayed. I double clicked on a column header and this is the result plus a bunch of "Error in FUNCTION RBListOfTables" among others. Creating the need to use the task manager to end the R:Base task. I do not have a full disk at all. Many more gigabytes of space than the size of the database. Thanks, --- Hans Manhave R:Base v.8
