Clarion 6.3 ABC, Cервер MySQL 5.1, MAV
!=== TPS файл ============
RECORD RECORD
N_EXP ULONG
N_GREXP ULONG
!===== MySQL ============
N_EXP int(13)
N_GREXP int(13)
Вот лог с MavTrace
Код: Выделить всё
9252392 Maximum read 1 rows for cursor
9252392 Parsing Cursor : SELECT * FROM MAVT_NakladImportExport WHERE 0=1
Calculate columns for cursor 9252392 Return Code : SQL_SUCCESS
Column 1 Name : "IdRecords" Size : 4 Type : 4 ColType : 4 null
Column 2 Name : "N_EXP" Size : 4 Type : 4 ColType : 4 not null
Column 3 Name : "N_GREXP" Size : 4 Type : 4 ColType : 4 not null
Column 4 Name : "Naklad" Size : 42 Type : -8 ColType : -8 null
Column 5 Name : "NumerHOST" Size : 2 Type : 5 ColType : 5 not null
Column 6 Name : "DataN" Size : 11 Type : 3 ColType : 1 null
Column 7 Name : "TimeN" Size : 11 Type : 3 ColType : 1 null
Column 8 Name : "OutN_ID_Items" Size : 2 Type : 5 ColType : 5 not null
Column 9 Name : "InN_ID_Items" Size : 2 Type : 5 ColType : 5 not null
Column 10 Name : "NWARES" Size : 4 Type : 4 ColType : 4 null
Column 11 Name : "EXPENSES" Size : 10 Type : 3 ColType : 1 null
Column 12 Name : "PRICE" Size : 12 Type : 3 ColType : 1 null
Column 13 Name : "UpdateDate" Size : 11 Type : 3 ColType : 1 null
Column 14 Name : "UpdateTime" Size : 11 Type : 3 ColType : 1 null
Column 15 Name : "VerifyCheckUp" Size : 1 Type : -6 ColType : -6 null
Column 16 Name : "VidOperationNaklad" Size : 1 Type : -6 ColType : -6 null
9252392 Close cursor
9252392 Free cursor
Calculate address fields for columns
Column 1 Name : "IdRecords" Address : 5560460
Column 2 Name : "N_EXP" Address : 5560464
Column 3 Name : "N_GREXP" Address : 5560468
Change column type 4 Name : "Naklad" Size : 19 Type : -8 ColType : 1
Column 4 Name : "Naklad" Address : 5560472
Column 5 Name : "NumerHOST" Address : 5560492
Column 6 Name : "DataN" Address : 5560494
Column 7 Name : "TimeN" Address : 5560498
Column 8 Name : "OutN_ID_Items" Address : 5560502
Column 9 Name : "InN_ID_Items" Address : 5560504
Column 10 Name : "NWARES" Address : 5560506
Column 11 Name : "EXPENSES" Address : 5560510
Column 12 Name : "PRICE" Address : 5560515
Column 13 Name : "UpdateDate" Address : 5560521
Column 14 Name : "UpdateTime" Address : 5560525
Column 15 Name : "VerifyCheckUp" Address : 5560529
Column 16 Name : "VidOperationNaklad" Address : 5560530
Calculate primary key fields
Column name "IdRecords" is primary key field
9252392 Open cursor
9252392 Binding field 1 `N_EXP` = -1794966837
9252392 Binding field 2 `N_GREXP` = -1794967288
9252392 Binding field 2 `N_GREXP` = -1794967288
как видим отправка уже с минусом ,
в оригинале что-то в этом роде:
N_EXP = 2 500 000 001
N_GREXP = 2 500 000 002
где копать ?