Search:

In the past, Lianja development roadmap was followed as given on your website. I hope to hear good news soon.

Best wishes,
Naeem

Another month gone. Any update about V2 release ?

Regards,
Naeem

Hi,

Already delayed Lianja V2 release.:( Is there any plan to share beta v2 with Lianja users ?

Regards,
Naeem

Hi Yvonne,

Thank for for sharing this information.

1) Any reply for my recent post ?

2) Can you share some information about table/cdx size changes after import ? Does Lianja needs more...

Hi Barry,

I use the following code in a prg file to select data from a vfp free table (having a memo field) via Lianja ODBC.


USE c:\temp\shpstkdat SHARED
SELECT * FROM shpstkdat INTO CURSOR...

Hi Barry,

As you said Lianja can read a vfp table directly. I need to run sql statement against it.

Is there any performance advantage in case i import this table to my Lianja DB or the sql...

Hi Barry,

Thanks. I was trying to use some gui in App builder but did not see any option there. A database import option is there but nothing for a single vfp table.

Is this possible in App...

Hi,

I need to import a free vfp table to one of my lianja sql server database.

Can you guide me how to do this or a web/blog link to do this ?

Regards,
Naeem

Yes, you are correct. This is replica of my ticket.

1) Is there a way that we can share our tickets on Lianja forums? So that others also get informed.

I got this reply against my ticket
...

Hi,

I have created a table in Lianja as

? SQLEXEC(lnconn,"Create table mytest (invno n(10) not null, dated t not null set default {})")

? SQLEXEC(lnconn,"select * from mytest")

?...

Good news for Lianja developers. I request you to add some modifications/enhancements in Lianja ODBC driver too. I have already submitted some tickets and still waiting for the solution. Lianja ODBC...

Is there any time limit for fixing the issues submitted via tickets ?

Regards
Naeem

Hi Cory,

Thank you for sharing a solution. I also want a solution from Lianja Team. I am more interested about the second part of my query of constant ODBC commands failure after this error.
...

Hi,

I used the following code to insert some data to a Lianja table through Lianja ODBC




lnconn = SQLCONNECT("LianjaODBC")

? SQLEXEC(lnconn,"CREATE table ctemp (cDesc c(200))")

Hi Yvonne,

We have many Lianja releases but still we need '.prg' file to execute the stored procedures. Can this be resolved in near future ?

Regards
Naeem

Hi Fabio,

Thanks for sharing.

Regards
Naeem

Hi All,

This the reply that I got against my ticket. Lianja index sum numeric fields to create unique index.

=============================================
Hi Naeem,

The command 'create...

I use the following code and get

Connectivity error: Cannot replace as key already exists

Can you explain why am I getting this error ?

================================
Code to produce the...

I saw it in Roadmap history as

? sqlexec(ConnHandle,"Lianja set date british")

What it does and what type of commands are allowed ?

I submitted my ticket with the Log file attachment. Waiting for a reply.

Hi,

I am using Lianja ODBC from VFP. I tried to set SQLSETPROP(ConHandle,"Transactions",2) to manual setting but it gave me this error

Warning: The connection transaction mode cannot be set.
...

Thank you.

Hi,

If you don't mind, Can you share us how many Lianja Licensed customers now ? How big is this community now? It may increase product adoption among other developers.

Good luck and best...

Hi,

Thanks for your reply. I had already done this. But there should be some Lianja ODBC setting which can make easy database level settings.

I am trying to set manual transaction property for...

Hi,

I tried to update date field in my Lianja table from VFP 9.0 sp2 through Lianja ODBC and my date setting was YMD. The command is

? sqlexec(lnConnHandle, "update mytable set dated =...