| Εκτύπωση | 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 |
| 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, ... |