In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

Search found 112 matches

Go to advanced search

by Milan Mehta
Tue Sep 17, 2019 3:52 pm
Forum: English
Topic: How to change Browse Header Foreground and Background Color
Replies: 1
Views: 35

How to change Browse Header Foreground and Background Color

I have set the background and foreground color of the Browse. However I could not change the same of the Header. It remains Black and white. How to change it ? Moreover I wish to highlight some cell. I could achieve the same using OnDrawCell event. But even after setting lHighLite to .T., I could no...
by Milan Mehta
Fri Feb 09, 2018 6:36 am
Forum: English
Topic: Error While Exiting from Application
Replies: 1
Views: 732

Error While Exiting from Application

I encounter following Error when I exit from all Xailer 5.0.3 compiled Application.

GPF (Code = c0000005):
Access violation

DESTROYWINDOW (0)
TBALLOON:DESTROY (92)
TBALLOON:END (84)
TAPPLICATION:END (241)
TERMINATEAPP$ (512)

What am I doing wrong ?
TIA
Milan.
by Milan Mehta
Sat Dec 02, 2017 8:10 am
Forum: English
Topic: Not Able to use :SendRequest
Replies: 2
Views: 1008

Re: Not Able to use :SendRequest

I did but it did not help. Is there any Sample code which is using :AddRequestHeader(), :SendRequest() and :QueryInfo(), So that I can Send Header Parameters and Body; I also wish to get the Response in the form of JSon file. It seems I am just one step away from achieving the same, but somehow find...
by Milan Mehta
Fri Dec 01, 2017 12:06 pm
Forum: English
Topic: Not Able to use :SendRequest
Replies: 2
Views: 1008

Not Able to use :SendRequest

My following code is not working at :SendRequest(). It is able to :Open(), :Connect() and :AddReqeustHeader(). But fails at :SendRequest(). However when tried with same Parameters in PostMan it works fine. What am I doing wrong ? TIA Milan. /----------------------------------------------------------...
by Milan Mehta
Sat Mar 04, 2017 11:48 am
Forum: English
Topic: Browse MariaDB Filter on Calculated Field
Replies: 0
Views: 640

Browse MariaDB Filter on Calculated Field

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.
by Milan Mehta
Tue Nov 29, 2016 11:15 am
Forum: English
Topic: Usage of TDataSet
Replies: 7
Views: 2495

Re: Usage of TDataSet

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.
by Milan Mehta
Sat Nov 26, 2016 3:07 pm
Forum: English
Topic: Usage of TDataSet
Replies: 7
Views: 2495

Re: Usage of TDataSet

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`...
by Milan Mehta
Thu Nov 24, 2016 8:07 am
Forum: English
Topic: Usage of TDataSet
Replies: 7
Views: 2495

Re: Usage of TDataSet

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...
by Milan Mehta
Wed Nov 23, 2016 3:23 pm
Forum: English
Topic: Usage of TDataSet
Replies: 7
Views: 2495

Usage of TDataSet

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.
by Milan Mehta
Mon Oct 24, 2016 10:07 am
Forum: English
Topic: Sqlite : How to disable Triggers temporarily ?
Replies: 1
Views: 1166

Sqlite : How to disable Triggers temporarily ?

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

TIA
Milan.
by Milan Mehta
Thu Sep 15, 2016 7:03 am
Forum: English
Topic: How to Trap key in Alt Combination ?
Replies: 4
Views: 1380

How to Trap key in Alt Combination ?

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.
by Milan Mehta
Mon Aug 08, 2016 10:18 am
Forum: English
Topic: How Can I add Image in Push Button ?
Replies: 1
Views: 955

How Can I add Image in Push Button ?

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

TIA
Milan.
by Milan Mehta
Sat Jun 04, 2016 3:50 pm
Forum: FastReport
Topic: FRX : Null Value in DataSet
Replies: 3
Views: 1622

Re: FRX : Null Value in DataSet

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
by Milan Mehta
Fri Jun 03, 2016 2:28 pm
Forum: FastReport
Topic: How to set Master-child relationship on multiple fields
Replies: 3
Views: 1529

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

No we use Sqlite. Can you guide ?

TIA
Milan.
by Milan Mehta
Sat May 28, 2016 7:26 am
Forum: FastReport
Topic: FRX : Null Value in DataSet
Replies: 3
Views: 1622

FRX : Null Value in DataSet

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.
by Milan Mehta
Sat May 28, 2016 7:24 am
Forum: FastReport
Topic: How to set Master-child relationship on multiple fields
Replies: 3
Views: 1529

How to set Master-child relationship on multiple fields

Please help me with an example of how to set Master-Child Relationship on Multiple Fields using :SetMaster().
by Milan Mehta
Tue Mar 15, 2016 9:27 am
Forum: English
Topic: How to attach Digital Signature to a PDF file ?
Replies: 1
Views: 873

How to attach Digital Signature to a PDF file ?

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.
by Milan Mehta
Wed Mar 02, 2016 1:39 pm
Forum: English
Topic: Trapping Keys in Browse
Replies: 2
Views: 1042

Re: Trapping Keys in Browse

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....
by Milan Mehta
Wed Mar 02, 2016 9:26 am
Forum: English
Topic: Trapping Keys in Browse
Replies: 2
Views: 1042

Trapping Keys in Browse

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 ...
by Milan Mehta
Wed Feb 03, 2016 3:40 pm
Forum: English
Topic: How to change the background color of TLabel ?
Replies: 1
Views: 762

How to change the background color of TLabel ?

As subject.

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

Thanks,
Milan.
by Milan Mehta
Fri Dec 25, 2015 8:03 am
Forum: English
Topic: Browse Filter Problem
Replies: 0
Views: 2202

Browse Filter Problem

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 ...
by Milan Mehta
Tue Oct 27, 2015 8:19 am
Forum: English
Topic: How to use Debugger in Xailer ?
Replies: 1
Views: 841

How to use Debugger in Xailer ?

Can you give us the brief outline of using Debugger in Xailer ?
by Milan Mehta
Sat Oct 17, 2015 10:42 am
Forum: English
Topic: Can I use C API function of Sqlite in our Code
Replies: 1
Views: 818

Can I use C API function of Sqlite in our Code

Can I use C API function of Sqlite in our code like sqlite3_finalize() ?
TIA
Milan.
by Milan Mehta
Wed Oct 14, 2015 4:44 pm
Forum: English
Topic: How can I change the Application Icon ?
Replies: 1
Views: 1148

How can I change the Application Icon ?

I did change it, but it does not change Icon of the Exe file generated by the Xailer.
by Milan Mehta
Tue Oct 06, 2015 9:05 am
Forum: English
Topic: Force Drop Down in SearchComboBox
Replies: 1
Views: 994

Force Drop Down in SearchComboBox

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.

Go to advanced search