Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bhavbhuti Nathwani
  Where is Bhavbhuti Nathwani?
 Rajkot
 India
 Bhavbhuti Nathwani
 Tags
Subject: ODBC returns 'not a table' error
Thread ID: 268968 Message ID: 268968 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Thursday, July 15, 2010 6:17:40 PM         
   


Hi all

I use Report Manager as the reporting mechanism. It thus relies on ODBC to connect to the free VFP tables created to report in this instance. The following account ledger module creates a free table, which I then populate with records, thus then used in Report Manager.

*** create the temp table for the ledger
CREATE TABLE (THIS.cCurLedger) FREE ;
	(iOrder I ;
		, iPID I ;
		, iGID I ;
		, tDt T ;
		, iAcctID I ;
		, bDebit B(THISFORM.nAmtDecimals) ;
		, bCredit B(THISFORM.nAmtDecimals) ;
		, cSource C(1) ;
		, mNarration M)

USE

USE (THIS.cCurLedger) ALIAS curLedger


Report Manager returns the following error:
---------------------------
VSORM repAccountLedger001.REP
---------------------------
Curledger:[microsoft][odbc Visual Foxpro Driver]not A Table..
---------------------------
OK
---------------------------

I have a similar stock ledger module with the exact same structure (slightly diff. field names) and that module works very well. I am not sure why this same structure fails in ODBC.

Please advise

Thanks and regards
Bhavbhuti

ENTIRE THREAD

ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/15/2010 6:17:40 PM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/15/2010 10:19:18 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 7:16:02 AM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/16/2010 12:58:59 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 2:11:21 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/16/2010 5:19:19 PM
RE: ODBC returns 'not a table' error Posted by Cetin Basoz @ 7/16/2010 10:28:52 PM
RE: ODBC returns 'not a table' error Posted by Bhavbhuti Nathwani @ 7/17/2010 6:40:04 AM