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.

Se encontraron 91 coincidencias

por Pedro Sousa e Faro
Mar May 22, 2012 6:15 pm
Foro: English
Tema: Capturing a return Value from Stored procedures
Respuestas: 2
Vistas: 1536

Capturing a return Value from Stored procedures

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+"'"+; &quo...
por Pedro Sousa e Faro
Mar May 22, 2012 5:43 pm
Foro: English
Tema: Capturing a return Value from Stored procedures
Respuestas: 2
Vistas: 1536

Capturing a return Value from Stored procedures

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 Ped...
por Pedro Sousa e Faro
Jue May 10, 2012 10:24 am
Foro: English
Tema: Field Date Edit (for SQL Databases)
Respuestas: 1
Vistas: 1059

Field Date Edit (for SQL Databases)

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 Rega...
por Pedro Sousa e Faro
Lun May 07, 2012 10:15 am
Foro: English
Tema: Linking errosys on apps
Respuestas: 7
Vistas: 2830

Linking errosys on apps

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@...
por Pedro Sousa e Faro
Vie May 04, 2012 11:35 am
Foro: English
Tema: Linking errosys on apps
Respuestas: 7
Vistas: 2830

Linking errosys on apps

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:...
por Pedro Sousa e Faro
Jue May 03, 2012 3:24 pm
Foro: English
Tema: Linking errosys on apps
Respuestas: 7
Vistas: 2830

Linking errosys on apps

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,...
por Pedro Sousa e Faro
Jue May 03, 2012 12:20 pm
Foro: English
Tema: Linking errosys on apps
Respuestas: 7
Vistas: 2830

Linking errosys on apps

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 i...
por Pedro Sousa e Faro
Mié Mar 21, 2012 11:53 pm
Foro: English
Tema: Tregistry(OpenKey)
Respuestas: 6
Vistas: 3468

Tregistry(OpenKey)

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 replicate th...
por Pedro Sousa e Faro
Mar Mar 20, 2012 2:17 pm
Foro: English
Tema: Tregistry(OpenKey)
Respuestas: 6
Vistas: 3468

Tregistry(OpenKey)

É 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-En...
por Pedro Sousa e Faro
Mar Mar 20, 2012 10:49 am
Foro: English
Tema: Tregistry(OpenKey)
Respuestas: 6
Vistas: 3468

Tregistry(OpenKey)

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$[emai...
por Pedro Sousa e Faro
Lun Mar 19, 2012 12:18 pm
Foro: English
Tema: Tregistry(OpenKey)
Respuestas: 6
Vistas: 3468

Tregistry(OpenKey)

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.0ExcelInsta...
por Pedro Sousa e Faro
Jue Nov 17, 2011 9:32 pm
Foro: English
Tema: how to determine nKey on ArrayBrowse1KeyDown
Respuestas: 0
Vistas: 6552

how to determine nKey on ArrayBrowse1KeyDown

Hi,
I need to know the nKey for the
Feminine Ordinal Indicator (chr(170),
obtained with SHIFT + ª Key .
Regards
Pedro
por Pedro Sousa e Faro
Lun Sep 27, 2010 10:10 am
Foro: English
Tema: Stopping a progress Bar
Respuestas: 2
Vistas: 1490

Stopping a progress Bar

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 Butto...
por Pedro Sousa e Faro
Vie Sep 24, 2010 6:04 pm
Foro: English
Tema: Stopping a progress Bar
Respuestas: 2
Vistas: 1490

Stopping a progress Bar

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. f...
por Pedro Sousa e Faro
Mié Sep 15, 2010 10:14 am
Foro: English
Tema: Xailer in 64 Bits
Respuestas: 3
Vistas: 1719

Xailer in 64 Bits

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...
por Pedro Sousa e Faro
Mar Sep 14, 2010 12:26 pm
Foro: English
Tema: Xailer in 64 Bits
Respuestas: 3
Vistas: 1719

Xailer in 64 Bits

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 future...
por Pedro Sousa e Faro
Lun Sep 13, 2010 5:21 pm
Foro: English
Tema: ToptionList
Respuestas: 2
Vistas: 1306

ToptionList

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] >...
por Pedro Sousa e Faro
Lun Sep 13, 2010 12:38 pm
Foro: English
Tema: ToptionList
Respuestas: 2
Vistas: 1306

ToptionList

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...
por Pedro Sousa e Faro
Vie Jul 02, 2010 4:22 pm
Foro: English
Tema: total pages in reports
Respuestas: 6
Vistas: 2772

total pages in reports

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 men...
por Pedro Sousa e Faro
Lun Jun 21, 2010 1:00 pm
Foro: English
Tema: TOptionList nChildIdent
Respuestas: 0
Vistas: 6909

TOptionList nChildIdent

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
por Pedro Sousa e Faro
Lun May 31, 2010 5:29 pm
Foro: English
Tema: Focus on Tradio
Respuestas: 2
Vistas: 1431

Focus on Tradio

É 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-Transf...
por Pedro Sousa e Faro
Lun May 31, 2010 2:04 pm
Foro: English
Tema: Focus on Tradio
Respuestas: 2
Vistas: 1431

Focus on Tradio

É 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-Transf...
por Pedro Sousa e Faro
Mié May 26, 2010 5:17 pm
Foro: English
Tema: FieldType date MSSQL
Respuestas: 4
Vistas: 2149

FieldType date MSSQL

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
por Pedro Sousa e Faro
Mar May 18, 2010 7:38 pm
Foro: English
Tema: Colors in ToptionItem
Respuestas: 2
Vistas: 1527

Colors in ToptionItem

Hi ,
Is it possible to assign a color to a optionItem in a OptionList ?.
Best Regards.
Pedro Faro
por Pedro Sousa e Faro
Mié Abr 21, 2010 2:00 am
Foro: English
Tema: Saving Images on Database
Respuestas: 2
Vistas: 1582

Saving Images on Database

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