Xailer & OZ Software

Pedro Sousa e Faro

Hi
Solved !!
For those who want to capture SP Output(the trick is to USE query instead of
Execute)
cmd="DECLARE @return_value int "+;
" EXEC @return_value = dbo.criacompromisso "+;
"'" +appdata:cod_ctc+"'"+;
",'"+appdata:data_enc+"'"+;
",'"+appdata:prc_compra+"'"+;
",'"+appdata:nota_enc ...

Pedro Sousa e Faro

Hi,
In Xailer i call ::ado:Execute("EXEC sp_sample ") to call and execute a
Stored Procedures .
Since Execute only returns .t. /.f. if SP runs OK, how can return the
"return value" of the SP ?
I tried with QueryValue but it's only accept "select" statements.
Regards
Pedro Faro

Pedro Sousa e Faro

Hi ,
Since our Xailer App's only work with MSSQL Server , the problem is that
MSSQL in Columns type "dateTime" only acepts dates > = 1753.
To validate the input we must insert a validation on "exit method" of any
date. "
Is ther any better way to validate this situation
Regards
Pedro Faro

Pedro Sousa e Faro

Tanks to all.
I didnÂ´t know that was so simple to call:
PROCEDURE ErrorSys() // --> n/a
Errorblock( { | oError | XSError( oError ) } )
RETURN
and change errorsys.prg (with other name) whatever ewe like.
Regards.
Pedro.
"Ignacio Ortiz de Zúñiga" escreveu na mensagem
news:4fa3f8d1$[email=1 ...

Pedro Sousa e Faro

Hi Ignacio,
Ok. Implemented thanks
One more thing.
Since our costumers doesn't have rights to write on apps folder , is it
possible the "error.log" can be written in other folder different for
aplication folder ?.
regards
Pedro
"Ignacio Ortiz de Zúñiga" escreveu na mensagem
news:4fa29716 ...

Pedro Sousa e Faro

Thanks Ignacio,
I would prefer first method, instead of +- errorsys on Xailer.lib
Can you publish a small sample how redirect " the errorBlock() ".
Regards
"Ignacio Ortiz de Zúñiga" escreveu na mensagem
news:4fa26cde$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
Pedro,
Is a ...

Pedro Sousa e Faro

Hi ,
I made a little change on errorsys.prg to capture "applications errors"
and sending by e-mail .
I link "errorsys" to my apps but it don't work.
Maybe Xailer is using the errorsys that remains in Xailer.lib instead of
errosys linked to the apps
How can i use errorsys linked in apps ...

Pedro Sousa e Faro

Hi Inacio,
In fact there is some combinations with Windows OS 32/64 and MsOffice 2010
32/64 :
OS 32 , Off 32 -> OpenKey Ok
OS 64 , Off 32 -> OpenKey Ok
OS 64 , Off 64 -> OpenKey No read with several combinations ...
I turn around with a default to Excel 2007 extension.
Unfortunaly i can ...

Pedro Sousa e Faro

É uma mensagem composta em formato MIME.
------=_NextPart_000_000A_01CD069B.CC1F6700
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_000B_01CD069B.CC1F6700"
------=_NextPart_001_000B_01CD069B.CC1F6700
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding ...

Pedro Sousa e Faro

Hi Ignacio,
I don't have Excel in Wow6432Node(the key doesnt exists):
" SOFTWAREWow6432NodeMicrosoftOffice14.0ExcelInstallRoot "
The code works ok in Xailer 2.0.18 with the same PC , nothing changes.
Regards
Pedro
"Ignacio Ortiz de Zúñiga" escreveu na mensagem
news:4f684a62$[email=1@svctag ...

Pedro Sousa e Faro

Hi,
Recently i upgraded Xailer 2.0x to 2.5
I Use the folowing code to get Excel Version :
METHOD ExcelExtensao() CLASS Copia2XLS
Local oWinReg
Local cExt
Local cFile
With Object oWinReg := TRegistry():New()
:Root := HKEY_LOCAL_MACHINE
DO CASE
CASE :OpenKey("SOFTWAREMicrosoftOffice12 ...

Pedro Sousa e Faro

Hi,
I need to know the nKey for the
Feminine Ordinal Indicator (chr(170),
obtained with SHIFT + Âª Key .
Regards
Pedro

Pedro Sousa e Faro

Hi Jose,
Thank's . Works fine.
Regards
Pedro
"Jose F. Gimenez" <jfgimenez@wanadoo.es> escreveu na mensagem
news:[email=4c9e60a8@svctag-j7w3v3j....]4c9e60a8@svctag-j7w3v3j....[/email]
> Pedro,
>
>> How can i stop a progress Bar that is running into a cycle, by pressing
>> on it , or a ...

Pedro Sousa e Faro

Hi
How can i stop a progress Bar that is running into a cycle, by pressing on
it , or a Buttom in the "form".
It Seems the only way to evaluate the progress Bar is with "ON change",
The other events "Click " , DBL Click" doesn't work while the progress
don't End.
for nl:=1 to aData:reccount ...

Pedro Sousa e Faro

Hi Mario,
I'm refering to Xailer in 64. No Xailer in 32, as actualy is .
32b app's works ok in 64 environments,
"Mário Angelini" <mario[at]emeasoft[dot]com[dot]br> escreveu na mensagem
news:4c8f903b$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
> We are using WIN7 Ultimate 64 ...

Pedro Sousa e Faro

Hi,
Xailer team is thinking to compile Xailer in 64 Bits ?
My Xailer's apps run only with SQL Server databases.
I've some customers , with Windows Server 2008 64 , SQL server 2008
Enterprise Edition 64 , and PC with windows 7 professional 64.
This environment becames in( our bussiness) a near ...

Pedro Sousa e Faro

Hi Ignacio,
Thank's . Didn't see in Manual.
WITH OBJECT ::oOptionList1:aItems[1]
msginfo(len(:tOptionItem:aItems))
END
Regards
Pedro Faro
"Ignacio Ortiz de Zúñiga" < NoNameToAvoidSpam@xailer.com > escreveu na
mensagem news:4c8e0297$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email ...

Pedro Sousa e Faro

Hi ,
I build a "ToptionList" with the Object Inspector .
I've have several "Subitems" in some "Items".
I need to disable by "code" some Subitems , but i notice that there isn't a
reference to that subitem.
How can we refer a subitem in a Toption List ?
Regards
Pedro Faro

Pedro Sousa e Faro

Hi Timm,
Are you the author of "Visual Designer ?. Great product !
Have you tried FastReports ?
In our big apps with Xailer we use FastReport anda works great !.
And is so simple to create complexed reports
Regards
Pedro Faro
"Timm Sodtalbers" < info@sodtalbers-it.de > escreveu na mensagem ...

Pedro Sousa e Faro

Hi ,
If i specify a nChildIdent of 10 , the SubItems are correctly idented.
If i add an Icon and keep the nChildident of 10 , the subitems go to much to
right-
I try a negative value of -10 and it seems that the subitems are now
ajusted.
This is the correct situation to do ?
Best regards ...

Pedro Sousa e Faro

É uma mensagem composta em formato MIME.
------=_NextPart_000_0013_01CB00DE.7B61D560
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0014_01CB00DE.7B61D560"
------=_NextPart_001_0014_01CB00DE.7B61D560
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding ...

Pedro Sousa e Faro

É uma mensagem composta em formato MIME.
------=_NextPart_000_0013_01CB00C1.C470B540
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0014_01CB00C1.C470B540"
------=_NextPart_001_0014_01CB00C1.C470B540
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding ...

Pedro Sousa e Faro

Hi,
Function ValType() of a Field Type "Date" on SqlServer returns "C" , but in
a field type "DATETIME" it returns correct "D",
Since SqlServer 2008 have this type of field, how can we use it in Xailer
App's
Regards
Pedro faro

Pedro Sousa e Faro

Hi ,
Is it possible to assign a color to a optionItem in a OptionList ?.
Best Regards.
Pedro Faro

Pedro Sousa e Faro

Hi
I need to save an "Image" in a database (MSSQL) field (Type IMAGE)
Anyone knows how to save and retrieve the Image using Xailer ?
best regards
Pedro

Se encontraron 91 coincidencias

Capturing a return Value from Stored procedures

Capturing a return Value from Stored procedures

Field Date Edit (for SQL Databases)

Linking errosys on apps

Linking errosys on apps

Linking errosys on apps

Linking errosys on apps

Tregistry(OpenKey)

Tregistry(OpenKey)

Tregistry(OpenKey)

Tregistry(OpenKey)

how to determine nKey on ArrayBrowse1KeyDown

Stopping a progress Bar

Stopping a progress Bar

Xailer in 64 Bits

Xailer in 64 Bits

ToptionList

ToptionList

total pages in reports

TOptionList nChildIdent

Focus on Tradio

Focus on Tradio

FieldType date MSSQL

Colors in ToptionItem

Saving Images on Database