I was asking if the fax program itself had a db, in which you could create a view - but it looks like that is not what happens at all. In this case, your best bet might be to create a M$ acce$$ db to receive the SQL statements and SATTACH the acce$$ db to the R:Base db.
"Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: >The fax program's source database would be our Rbase database. I could >create a view inside the Rbase DB, but I'm not sure what you are getting >at doing with it. Due to the fact that the Fax application issues >direct SQL to the ODBC driver, I don't think wrapper views would work. >If you are thinking of some other solution, please let me know as I'm >screwed otherwise. > >Thanks, >Eric > > >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >On >> Behalf Of Albert Berry >> Sent: Thursday, October 04, 2001 12:28 PM >> To: [EMAIL PROTECTED] >> Subject: RE: Name length limitation >> >> Can you create a view in the fax program source database that renames >the >> fields to 18 characters or less? >> >> >> >> "Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: >> >> >Our Fax program can use an ODBC source for archival purposes. The >> >tables that it uses are hard coded into their program, and some of >the >> >field names are longer than 18 characters. >> > >> >Is there anyway around this? >> > >> >Thanks, >> >Eric >> > >> > >> > >> >> >> __________________________________________________________________ >> Your favorite stores, helpful shopping tools and great gift ideas. >> Experience the convenience of buying online with Shop@Netscape! >> http://shopnow.netscape.com/ >> >> Get your own FREE, personal Netscape Mail account today at >> http://webmail.netscape.com/ > > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
