scratch C:\Users\TOMTOS~1\AppData\Local\Temp under ODBC Data Source Administrator there is no Rbase driver This is how I sconnect set var zTotalName text = (.vQuote+';Driver=R:Base 7.6 DataBase Driver (*.rb1);dbq='+.vSgetName+.vQuote) sDetach zSalesTab nocheck sDetach zInventorytab nocheck sdisconnect &zTotalName SCONNECT &zTotalName SATTACH SalesTab as zSalesTab using all SATTACH InventoryTab as zInventoryTab using all
I connect to both databases fine and part 1 works but part 2 is where the error message happens Part 1 update SalesTab set ConsignNum = T2.ConsignNum,BrandName = T2.BrandName,+ ItemSize = T2.ItemSize,ItemDate = T2.ItemDate,StyleName = T2.StyleName,descipt = T2.descipt,+ ConComm = T2.ConComm,ItemCost = T2.ItemCost+ from SalesTab T1, tmpItab T2 where T1.ProdNum = T2.ProdNum and T1.ItemDate is null Part 2 update zSalesTab set ConsignNum = T4.ConsignNum,BrandName = T4.BrandName,+ ItemSize = T4.ItemSize,ItemDate = T4.ItemDate,StyleName = T4.StyleName,descipt = T4.descipt,+ ConComm = T4.ConComm,ItemCost = T4.ItemCost+ from zSalesTab T3, tmpItab T4 where T3.ProdNum = T4.ProdNum and T3.ItemDate is null ________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, February 4, 2009 3:43:39 PM Subject: [RBASE-L] - Re: SConnect database question At 04:29 PM 2/4/2009, TOM HART wrote: > I am using 7.6 DSN-less on one computer, not over a network. > I forgot to include the error message: > Error: disk problem please check disk or files A few suggestions: 01. Make sure that the R:BASE 7.6 for Windows ODBC Driver is configured accordingly. To Verify: ODBC Data Source Administrator | Drivers Name: R:BASE 7.6 Database Driver (*.rb1) Version: 7.06.06.30214 Company: R:BASE Technologies, Inc. File: RB76_32.DLL Date: 2/14/2009 (your version number and dates may vary) 02. What is the setting for SCRATCH? At the R> prompt: SHOW SCRATCH 03. Take a look at the sample application below to demonstrate the fundamentals of using DSN-Less Connection. Sample Applications: http://www.razzak.com/sampleapplications Application: Migrating Data Using DSN-Less Connection Date Posted: 10/28/2008 Hope that helps! Very Best R:egards, Razzak.
