Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Bhavbhuti Nathwani
  Where is Bhavbhuti Nathwani?
 Rajkot
 India
 Bhavbhuti Nathwani
 Tags
Subject: RE: ODBC returns 'not a table' error
Thread ID: 268968 Message ID: 268996 # Views: 51 # Ratings: 2
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Thursday, July 15, 2010 10:19:18 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

Did you try ADS ODBC driver instead or copy to type fox2x. I think the problem isit doesn't recognize VFP9 table (or maybe you create an empty table in VFP6 and use a copy of it when you need?).

PS: I don't understand why it would use ODBC but not OLEDB.

Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)

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