Search:

Try:

DATABASE=BDFICC

SCAN ... ENDSCAN is documented here:

http://www.lianja.com/doc/index.php/SCAN

The "&" character indicates a macro substitution:

http://www.lianja.com/doc/index.php/%26

So basically the...

As long as the DSN exists when you try to use it then you shouldn't have any issues.

Lianja currently only supports 32 bit ODBC drivers so you will want to verify that you are using the 32 bit version of the SQL Server ODBC driver as well as the 32 bit ODBC Administrator (usually...

Hi Cory,

"m.varname" is a VFP convention, not JavaScript. Try removing the "m.".

What is the key expression for the tag?

Hi Fabio,

This is expected behavior and exactly what VFP does if there are no records in a table. If the table is at EOF then RECNO() will report RECCOUNT()+1.

Hope this helps.

Hi Cory,

Can you be a little more specific? It's probably just me, but the way I'm reading your post it seems to be contradicting itself. The first paragraph seems to be asking about a...

Hi Cory,

Check out SYSRESULTSET:

http://www.lianja.com/doc/index.php/SYSRESULTSET

You should be able to do something like this:

SELECT FILE("orders.dbf") AS mylogical FROM SYSRESULTSET

Hi Frank,

Lianja does this via Virtual Tables. Take a look at this doc, it should tell you everything you need to get started:

http://www.lianja.com/doc/index.php/Virtual_Tables

Hi Larry,

Lianja also saves changes you make to your App, so if you find that you've broken something you can use the Versions Workspace to restore an earlier version of the App.

Hi Cory,

If I'm understanding what you're asking you could pass the array name and macro substitute it where necessary. Something like this, but with the looping:


public arr1(5,3)
arr1(1,1)...

Hi acrien,

Bear in mind that Lianja is designed to help you be as productive as possible by allowing you to create Apps with little to no code. That being said, you can use code in a couple of...

Just download and install the new version. Anyone that has a licensed copy of 1.x is entitled to version 1.3 at no additional charge.

Sorry, I seem to always be a step behind! :D Looks like you're back to testing with telnet using the link I posted above.

Just double checking the doc - you may also have to BASE64_ENCODE() the user/pass:

http://www.lianja.com/doc/index.php/MAILOPEN%28%29

Looks like you've got an ESMTP server then. We just added support for ESMTP so you should be able to just replace SMTP with ESMTP.

Hi Cory,

The settings in Outlook should include the port.

You can also use telnet to test SMTP:

https://technet.microsoft.com/en-us/library/aa995718%28v=exchg.65%29.aspx

Hi Fabio,

A VT can be created against a local table. Just specify "local" as the ODBC Connection and enter a SQL statement.

Hi Cory,

DEFAULT() or even SYS(2003) should do it for you.

For development purposes you can create a config.db in the .\Lianja\conf\ directory and put your SET commands there.

Hi Herb,

Yes, there is VT support in the 1.3 RC 10 release.

Hi Harry,

Thanks, I was able to reproduce the behavior with the logical column and submitted a new ticket under your name. You should be receiving emails as the tickets are updated, or, as Hank...

This is specifically an issue with setting the default in the table column attribute - setting it in the form/grid works fine. A ticket has been opened.

Thanks Harry,

As I mentioned on the ticket, the relationship was unnecessary - removing it solved the problem.