Select fron a vfp table that is not part of a database

Thanks Barry,

I've submitted a ticket with the DDENT files.

David

Hi David,

I am able to USE that table and COPY TO another_name to put it in Lianja format.

SQL SELECT is working Ok in 3,.4 with that table too although its not really supported as you need to convert to Lianja format so that the query optimizer can do its work.

I will make 3.4RC available to you in the beta directory but bear in mind this includes the new CodeAssistant and Intellisense.

I will close the ticket.

Attachment 1459

Thanks Barry,

I'll download that and try.

The sql stuff I ned to do on this is very simple and I'd rather keep it all in selects into a cursor for what I want to do.

David

Hi David,

Just USE tablename ALIAS whatever then perform your SQL SELECTSs.

Just an FYI, Lianja supports the following XBase file formats natively readonly.

VFP
FoxPro 2.x
Clipper

Thanks Barry

This will allow me to use Xcase for all my data modelling and have a prg create / update all the tables, indexes etc in Lianja.

David

Hi David,

I've given you prerelease access to the beta directory but you may need to logout and login again to the main site.

Hi Barry,

I logged out then tried to log in, put wrong password first time and system told me that

Entered correct one ( I think) and get

Shut down browser and tried again and it worked

Quote:

---

Originally Posted by avianmanagement

Shut down browser and tried again and it worked

---

Yes probably a caged cookies.

Lianja 3.4RC4 is currently uploading so wait about 5 minutes.

Enjoy.

Got in and was download the beta, cancelled that now and will wait a while and get RC4

Thanks