##### UniPOS/ ORDER Plus

Εκτύπωση | DOCID | Flexno
Εκτέλεση (παραγωγή) |  | 1
Απόδειξη-Taxspooler |  | 2
Ανάλυση |  | 3
Εξόφληση |  | 4
Απόδειξη-Ταμειακή |  | 5
ΤΙΜΟΛΟΓΙΟ | 6 | 6
X-report |  | 7
Δ/Α | 1 | 8
ΤΔΑ | 2 | 9
print_smen_barcode |  | 10
ΔΕΛΤΙΟ ΠΑΡΑΛΑΒΗΣ | 3 | 11
ΠΙΣΤ.-ΔΕΛΤ./ΠΑΡΑΛΑΒΗΣ | 4 | 12
ΑΚΥΡΩΤΙΚΟ | 5 | 13
ΔΕΛΤΙΟ ΛΙΑΝΙΚΗΣ | 7 | 2

##### Convert mysql -> SQL server

Origin (mysql) | MySql | SQL2000
--- | --- | ---
REPLACE | $db->Replace | $db->Replace
Table/ row Locks |  | GET_LOCK()
Lock: FOR UPDATE |  | WITH (UPDLOCK)
DEFAULT VALUES |  |
NOW() |  | GETDATE()
LENGTH() |  | DATALENGTH()
Date reading |  | (set global var at begining)
ALTER TABLE old_name RENAME TO new_name |  | EXEC sp_rename 'old_name', 'new_name'
SUBSTRING() function
LIMIT
DATE_FORMAT( date, '%Y-%m-%d' ) | XDATE(date) | XDATE(date)
EXTRACT(type FROM date) |  | DATEPART(datepart, date)
PATH_TRANSLATED | cMOBILE::docRoot | cMOBILE::docRoot

mysqlt | ado_mssql
DESCRIBE tablename | EXEC sp_columns @table_name = 'tablename'
Returns Fields, Type, Null (YES), Key, Default, Extra | Returns TABLE_NAME, COLUMN_NAME, DATA_TYPE (int), TYPE_NAME, PRECISION, LENGTH, SCALE, RADIX, NULLABLE (int), REMARKS, COLUMN_DEF, ...
$db->MetaPrimaryKeys('tablename') | sp_pkeys @table_name='tablename'
Returns array of field names | Returns recordset with fileds: ..., COLUMN_NAME, ...