Xailer forum

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)Â

Milan Mehta

One Problem we have been facing is :
Whenever we use MsgInfo() in Exit Event of any Control, the Focus shifts to the First Data Control of the Form. We wish to remain on the same control or the next control.
What should we do for that ?
TIA
Milan.

Milan Mehta

Yes it did solve the problem.
Thanks
Milan.

Milan Mehta

While Linking with new Xailer 4.0, I get the following error. I have Rebuilt the Project. Linking: SagarAct.exe... C:/Xailer4/hb32/Lib/Win/mingw/libhbrtl.a(hbsocket.o):hbsocke t.c:(.text+0x9c60): undefined reference to `[email=GetAdaptersInfo@8']GetAdaptersInfo@8'[/email] C:/Xailer4/hb32/Lib/Win/min...

Milan Mehta

Does BeginTrans() have the option to start transaction in Exclusive mode in Sqlite ?
TIA
Milan.

Milan Mehta

What is the standard procedure to be followed in the cases where concurrent users try to save data in Sqlite database ?
Quite often we get the error : Database is locked [#5].
TIA
Milan.

Milan Mehta

I am having Enterprise Edition of Xailer and FRX. But it does not allow me to use PrepareReport().
What is the way out ?
TIA
Milan.

Milan Mehta

Can I execute Multiple statement seperated by ; in one DataSource:Execute() command ?
If not, is there any work around ?
TIA
Milan.

Milan Mehta

Ultimately following statement solved my problem.
PRAGMA busy_timeout = milliseconds;
oDS:Execute ("PRAGMA busy_timeout = 10000;")
Thanks
Milan.

Milan Mehta

I am using Sqlite datasource. It seems that while insert / update / deleting a record in any table in the databases, entire database file gets locked. So when concurrent users tries to Save record, we get the error : Database locked. How can we avoid this error ? How do we detect the problem and kee...

Milan Mehta

Sometime the situation arises when value of Field of underlying Dataset has changed, how can I enforce corresponding value change of the associated TDbMaskEdit ?
TIA
Milan.

Milan Mehta

Quite often while doing Database Operation in Sqlite we come across this error - interruped [#9] and transaction is rolled back. But however if we do the same operation in Sqlite studio or similar workbench we do not face this problem.
Is there any way to resolve the issue ?
TIA
Milan.

Milan Mehta

In MySql we have the facility of Stored Procedure or Function. Is there similar functionality available for Sqlite ? If so writing SQL becomes lot more powerful.
Kindly guide,
TIA
Milan.

Milan Mehta

My following lines of code give me error : Code : oExcel := Win_OLECreateObject( "Excel.Application" ) oExcel:Workbooks:Open("abc.xls") ::oExcel:Visible := .T. oAS := oExcel:ActiveSheet() oAS:Cells ( 1, 3 ):Interior:ColorIndex := 7 Error : Subsystem Call: WINOLE System Code: 1006...

Milan Mehta

We have DatePicker and TimePicker controls. But is there any way by which I can accept both togather in one control ? So that I can bind it to a datetime field ?
If not, what is work around ?
Kindly guide.
TIA
Milan.

Milan Mehta

Thanks a lot. I too started working keeping lDateAsString := .T. and the result is encouraging.
Regards,
Milan.

Milan Mehta

I have been facing this problem randomly. When I try to store pure numeric value in a character field, Xailer stores some funny value. Like when I tried to store value 121 in Varchar(7) field, it stores value like -21456. This is consistently happening in a field. However it is working fine in other...

Milan Mehta

Sqlite normally stores data as numeric value in the database. Xailer gives us the option to store the date value as numeric value (as default for sqlite) or store it date as character sting. My question what is proper and prevalent method of storing Dates in Sqlite ? As Numeric Value or as Date char...

Milan Mehta

It seems that these two functions are of use to me.
From where can I get the source of it ?
What exactly it does ?
TIA
Milan.

Milan Mehta

Yes it worked well. Thanks.
Milan.

Milan Mehta

At some point, I wish to Put some text in the clipboard.
How can I ?
hb_gtInfo( HB_GTI_CLIPBOARDDATA, "sample text" )seems to be not working.
TIA
Milan.

Milan Mehta

I suddenly started having problem with a project using Frx. My following code started giving problem. When I run the program execution at this point, windows gives out error : "windows has stopped working." WITH OBJECT oReport := TFastReport():New( Self ) :AddDataSet( "MemDataSet"...

Milan Mehta

I had read somewhere that this is possible.
How can I embed .fr3 file in Exe created by Xailer ?
TIA
Milan.

Milan Mehta

Thanks. It worked.
Can it be used in Code Script (VB, Java or Pascal script) of the report ? Perhaps Not.
If not any work around ?
TIA
Milan.

Milan Mehta

Previously we had CallHBVar() function available in Fast Report.
What is the alternative in the new FR ?
TIA
Milan.

Se encontraron 134 coincidencias

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

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

Xailer 4.0 Linking Error

Xailer 4.0 Linking Error

Sqlite : BEGIN TRANSACTION EXCLUSIVE

Sqlite : Concurrent User Problem

Not Able to use PrepareReport() with FRX

Can I execute multiple Statements in one DataSource:Execute() command ?

Sqlite : Database locked problem

Sqlite : Database locked problem

How to update Value of TDBMaskEdit ?

Sqlite Error : Interrupted [#9]

Sqlite : Any substitute for Stored Procedure or Function ?

Win_Ole Error, Dos Error Code: -2147352567

How to accept DateTime Value ?

Sqlite : What is proper practice to store Date field ?

Sqlite : Funny behavior while saving numeric value in char field.

Sqlite : What is proper practice to store Date field ?

Where can I get Source of WaitOn() and WaitOff()

How can I copy to clipboard ?

How can I copy to clipboard ?

Error Loading Frx

How can I embed .fr3 file in Exe ?

How to pass Parameter from Xailer to FR ?

How to pass Parameter from Xailer to FR ?