bb.donnay-software.com

In PostgreSQL, table names and column names are case-sensitive, but with some caveats. Table Names By default, PostgreSQL converts table names to lowercase, unless they are quoted. This means that: - `CREATE TABLE MyTable` will create a table named `mytable`. - `CREATE TABLE "MyTable"` will create a...

Hi all

How can I set case sensitivity off in postgresql

Thanks

Joe

Hi all, In SQLExpress, I uploaded a table from ADS/adt to Postgresql 16 using ODBC. Everything looks fine in pgAdmin 4. But when i make a cursor using SQLDataset():New() and retrieve a boolean field in my test application, like oCursor:fieldget("myBooleanFld"), I get string "1" for TRUE and string "...

I had always believed that pgdbe is a misadventures and unnecessary. SQL Express or powersql is the way to go. Features like ability to use .net and vcl components would be more useful than this road to nowhere called pgdbe. I use sqlexpress and loved it. Cut my codes in reporting by more than 40 pe...

Hi Slavko I appreciate everyone on this platform and has always been grateful. It must have been an oversight for not offering you thanks for your help not deliberate. So many thanks. Now another help request. I use sqlexpress which uses odbc and fine for me despite some limitations in dcbrowse comp...

Hi Tom Thanks again for your response. If multi core support truely improve performance then it would have been better for Alaska to fix the problem rather than abandoning it albinitio. As per 64bit Alaska may need to find a way to accommodate it since it allows applications to access more memory. T...

Hello everyone there.

Are there reasons why Alaska is avoiding multi core support and 64bit application

I am just being curious.

Thanks

Joe

Hi Slavko

Kind upload a demo of your solution for our benefits. Quite interested

Thanks

Joe

Hi Skiman Thanks for your response. Your above code not working. My validation code in the valid clause is Iif(empty(o:getdata(), msgbox("item empty",nil) Could you please review your code and give me a complete sample based on my validation. I also noticed that you declared o and lol in the valid c...

Hi Skiman

Could kindly post your solution to this problem.

Thanks

Joe