Search found 18 matches

by ohernandez@sistemas-liasa.com
Wed Jun 03, 2020 10:11 pm
Forum: Product
Topic: ADS error 7200: There is an error converting Unicode string to or from code page
Replies: 20
Views: 5647

ADS error 7200: There is an error converting Unicode string to or from code page

<t>Hi wolfgang,<br/>
To log errors try sp_EnableQueryLogging(<br/>
TableName, Character, 255,<br/>
TruncateExistingData, Boolean,<br/>
LogOnlyUnoptimizedQueries, Boolean,<br/>
MinimumTimeBeforeLogging, Integer,<br/>
EncryptionPassword, Character, 20,<br/>
Options, Integer ),<br/>
with a 1 in ...
by ohernandez@sistemas-liasa.com
Tue Nov 12, 2019 7:49 pm
Forum: Product
Topic: Porting VO Forms to Winform or WPF
Replies: 22
Views: 6894

Porting VO Forms to Winform or WPF

Hi Chris,
Thank You, this will help a lot in the migration to x#.

Oscar Hdz.
by ohernandez@sistemas-liasa.com
Sat Aug 31, 2019 3:38 pm
Forum: Chit-Chat
Topic: Loading info using interop
Replies: 4
Views: 2169

Loading info using interop

Robert, Chris,
Thanks for the tip, looking for properties like Formula, we found displaytext that did the work.
We will change from a massive way to import into cell by cell using displaytext for the fields that expect string.
by ohernandez@sistemas-liasa.com
Fri Aug 30, 2019 10:32 pm
Forum: Chit-Chat
Topic: Loading info using interop
Replies: 4
Views: 2169

Loading info using interop

<t>Hi,<br/>
I have a problem importing files from excel, when the cell contents "800 3/4" as a raw material code, the result is loaded as 800.75.<br/>
I am using: <br/>
VO through Excel.Application.<br/>
.NET Interop.<br/>
.NET Devexpress worksheet.<br/>
Excel ole connection.<br/>
All of them import ...
by ohernandez@sistemas-liasa.com
Thu Jul 25, 2019 9:19 pm
Forum: VO & Vulcan
Topic: Advice on Column sorting bBrowser please
Replies: 4
Views: 2073

Advice on Column sorting bBrowser please

<t>Hi jeff,<br/>
I do:<br/>
oServer := oEvent:Control:Server<br/>
iSize := oServer:OrderInfo(DBOI_ORDERCOUNT)<br/>
FOR iPos:=1 upto iSize<br/>
IF cExpression=Upper(oServer:OrderInfo(DBOI_EXPRESSION,, iPos)) <br/>
exit<br/>
ENDIF<br/>
NEXT<br/>
…<br/>
oServer:SetOrder(iPos)<br/>
…<br/>
swap ...
by ohernandez@sistemas-liasa.com
Sat Jan 05, 2019 4:08 pm
Forum: Chit-Chat
Topic: The X# devteam wants to meet you !
Replies: 12
Views: 3918

The X# devteam wants to meet you !

We booked the hotel for 3 participants.
by ohernandez@sistemas-liasa.com
Mon Oct 22, 2018 2:36 am
Forum: Chit-Chat
Topic: The X# devteam wants to meet you !
Replies: 12
Views: 3918

The X# devteam wants to meet you !

Sorry I did not see this before,
Please count 3 more for Austin.
by ohernandez@sistemas-liasa.com
Mon Jan 01, 2018 7:48 pm
Forum: Chit-Chat
Topic: finding .NET friendly Reporting tools (third party) ? HELP !
Replies: 16
Views: 4638

finding .NET friendly Reporting tools (third party) ? HELP !

<t>Phil,<br/>
We are using Dev Express, we have 100s of reportpro reports; but looking for a friendly interface to the user, we configure grids that allow them from a SQL (advantage database ADT) query to change the orders, groups, filters(complex), sums, pivot table, in the grid and the user can ...
by ohernandez@sistemas-liasa.com
Wed Nov 22, 2017 11:11 pm
Forum: VO & Vulcan
Topic: Advantage Database Server ADT files & Report Pro
Replies: 2
Views: 2594

Advantage Database Server ADT files & Report Pro

<t>Yes, We are using them from several years.<br/>
You can use the rdd, or you can swap the tables like:<br/>
CSCRIPT:=self:swapvariables(AllTrim(self:oTPTABREPORTES_REPORTES:oDCbrowListaRepo:server:SCRIPT)) <br/>
ODB := AdsSQLServer{ CSCRIPT, true ,FALSE , "AXSQLADT" }<br/>
if ODB:Used<br/>
AAdd ...
by ohernandez@sistemas-liasa.com
Wed Nov 15, 2017 7:18 pm
Forum: VO & Vulcan
Topic: SQL fieldtype changes when a query is modified to sort; GetData returns nothing
Replies: 3
Views: 2601

SQL fieldtype changes when a query is modified to sort; GetData returns nothing

<t>Dick,<br/>
I had the same problem getting info from the system objects y ADS, the cicharacter returned empty fields.<br/>
What I did was to create an empty structure and insert into it.<br/>
Something like:<br/>
part of the script...<br/>
"SELECT CONVERT(SPACE(200),SQL_CHAR) NOMBRE, FALSE Table ...