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

[avianmanagement]

Thanks Barry,

I've submitted a ticket with the DDENT files.

David

[barrymavin]

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.

[avianmanagement]

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

[barrymavin]

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

[avianmanagement]

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

[barrymavin]

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.

[avianmanagement]

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

[avianmanagement]

Shut down browser and tried again and it worked

[barrymavin]

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.

[avianmanagement]

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

Thanks