Xailer forum

Milan Mehta

DataSource : MariaDB
One particular problem while filtering on Calculated Field in Browse it gives out error.
The reason is Where condition do not allow LIKE '%xxx%'.
(However it is allowed in Having Condition).

Is there any way out ?

TIA
Milan.

Milan Mehta

I tested your project. But it still do not show Primary Keys.
My Xailer is 4.0.2 (June 2015).
Should I check anything else ?

TIA
Milan.

Milan Mehta

Here is DDL : CREATE TABLE `exppcinv` ( `exppcinvbook` CHAR(2) NOT NULL, `exppcinvexunitcode` SMALLINT(5) UNSIGNED NOT NULL, `exppcinvvno` SMALLINT(5) UNSIGNED NOT NULL, `vdate` DATE NOT NULL, `party` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `buyer` SMALLINT(5) UNSIGNED NULL DEFAULT NULL, `buyerlcno`...

Milan Mehta

Ok. I tried following code. However it always returns lPrimaryKey as .F. even in case of Primary Key field. I use MariaDB database. WITH OBJECT oTable := TSqlTable():Create() :oDataSource := AppData:oDS :cTableName := 'exppcinv' :lOpen := .T. aTabFields := oTable:aFields END WITH FOR i = 1 TO Len(aT...

Milan Mehta

I am using MariaDB Data Source. My following code do not work and gives me error at cName Property assignment. WITH OBJECT oTable := TDataSet():Create() :oDataSource := AppData:oDS :cName := 'exppcinv' :lOpen := .T. aTabFields := oTable:aFields :lOpen := .F. END WITH What am I doing wrong ? TIA Milan.

Milan Mehta

Is there any way to suspend Triggers and then Reactivate it in Sqlite ?

TIA
Milan.

Milan Mehta

I wish to use Alt+W key in FormKeyUp Event of the Form (using VK_ combination).
I could See Control+ or Menu+ Combination but not Alt+ Combination.
I am including WinUser.api.

Is it possible or is there any work around ?

TIA
Milan.

Milan Mehta

I need to have Big Push Button with Image. How can I ?

TIA
Milan.

Milan Mehta

My following code is giving me error : "No Exported Variable lConvertNulls"

WITH OBJECT oReport := TFastReport():New(self)

:oEngineOptions:lConvertNulls := .T.

END WITH

What am I doing wrong ?

TIA
Milan

Milan Mehta

No we use Sqlite. Can you guide ?

TIA
Milan.

Milan Mehta

When using FRX, if there is any Null value in the DataSet passed, it results in hanging of the application.

What is the way out ?

TIA
Milan.

Milan Mehta

Please help me with an example of how to set Master-Child Relationship on Multiple Fields using :SetMaster().

Milan Mehta

How can I attach Digital Signature to a PDF file generated from Fast Report using Xailer ?

If Xailer does not give this feature, is there any workaround ?

TIA
Milan.

Milan Mehta

Dear Sir, It gives me information of Key Pressed in OnKeyUp Event but does not give me any information of Key Pressed in OnChar Event of the form. Do I need to set any other property ? One more observation : When I set OnChar Event of the form, the Property lMsgAuto is automatically set to value .T....

Milan Mehta

I wish to trap Keys pressed by user in the Browse. I wish to automatically search that value in a particular column. The problem arises when user Presses key like Down, nKey Returns a values which is equal to ( character, similarly Up is equal to & character etc. Is there any way by which I can ...

Milan Mehta

As subject.

I tried to change the property of ClrPane but it had no effect on the appearance.
Kindly guide.

Thanks,
Milan.

Milan Mehta

I am using Sqlite and MySql Datasource. How to Set filter on Numeric Columns in Browse ? My following code seems to be not working : :oBrowSch:lFilterBar := .T. ::oBrowSch:aCols[4]:cFilter := ::oItemName:cText ::oBrowSch:aCols[6]:cFilter := LTrim(Str(::oPkgQty:cText)) // Numeric Column After giving ...

Milan Mehta

Can you give us the brief outline of using Debugger in Xailer ?

Milan Mehta

Can I use C API function of Sqlite in our code like sqlite3_finalize() ?
TIA
Milan.

Milan Mehta

I did change it, but it does not change Icon of the Exe file generated by the Xailer.

Milan Mehta

I have a typical requirement. I have a search combobox. If the user Presses Enter keeping it empty, I wish to force open the Drop down list (Normally available by Pressing Down Arrow Key).

Is it possible ? If so, how ?

TIA
Milan.

Milan Mehta

Is there any limitation to no. of records that can be stored in MemDataSet ?
It is being observed that I am not able to add more than 28000 records in MemDataSet.
Thereafter it simply exits the program.
Can you please shed light on the issue.

TIA
Milan.

Milan Mehta

Thanks Ignacio. We are eagerly awaiting the new release.

Milan.

Milan Mehta

Dear Sir,

I am trying to Print a number 2920687188 it prints -1374280108. I am using default %2.2f display format.
Can you suggest me proper display format so that it prints properly.

TIA
Milan.

Milan Mehta

Please try the attached sample.
After the Search Combo Box, the Message appears and focus shifts to the first control of the form.
TIA
Milan

Attached files MsgInfo.zip (3.8 KB)Â

Se encontraron 133 coincidencias

Browse MariaDB Filter on Calculated Field

Re: Usage of TDataSet

Re: Usage of TDataSet

Re: Usage of TDataSet

Usage of TDataSet

Sqlite : How to disable Triggers temporarily ?

How to Trap key in Alt Combination ?

How Can I add Image in Push Button ?

Re: FRX : Null Value in DataSet

Re: How to set Master-child relationship on multiple fields

FRX : Null Value in DataSet

How to set Master-child relationship on multiple fields

How to attach Digital Signature to a PDF file ?

Re: Trapping Keys in Browse

Trapping Keys in Browse

How to change the background color of TLabel ?

Browse Filter Problem

How to use Debugger in Xailer ?

Can I use C API function of Sqlite in our Code

How can I change the Application Icon ?

Force Drop Down in SearchComboBox

Any Limitation to No. of Records in MemDataSet ?

Re: Not Able to Print Big Number

Not Able to Print Big Number

MsgInfo() Sets Focus on the First Control of the Form