Configurações Aparelho Windev Mobile
IF SysStatusStorageCard()=sysCardAvailable THEN // se existe cartao
Info("igual")
Info("sysCardAvailable"+CR+sysCardAvailable) // 1
Info("SysStatusStorageCard"+CR+SysStatusStorageCard()) // 1
Info("SysAndroidVersion"+CR+SysAndroidVersion()) // kitkat tablet di // jelly bean celular sansug
Info("SysDirStorageCard"+CR+SysDirStorageCard) // /storage/emulated/0 Tablet /// /storage/sdcard0 do celular
Info("SysIdentifier"+CR+SysIdentifier) // ad5198b2900ce6e5
Info("SysScreenOrientation"+CR+SysScreenOrientation()) // 90
Info("SysSerialNum"+CR+SysSerialNum()) //
Info("SysWindowsVersion"+CR+SysWindowsVersion()) // android 4.4.2 // 4.1.2
Info("SysXRes"+CR+SysXRes()) // 600 // 320
Info("SysYRes"+CR+SysYRes()) // 1024 // 480
ELSE
Info("diferente")
Info("sysCardAvailable"+CR+sysCardAvailable)
Info("SysStatusStorageCard"+CR+SysStatusStorageCard())
Info("SysAndroidVersion"+CR+SysAndroidVersion())
Info("SysDirStorageCard"+CR+SysDirStorageCard)
Info("SysIdentifier"+CR+SysIdentifier)
Info("SysSerialNum"+CR+SysSerialNum())
Info("SysWindowsVersion"+CR+SysWindowsVersion())
Info("SysXRes"+CR+SysXRes())
Info("SysYRes"+CR+SysYRes())
END
terça-feira, 20 de janeiro de 2015
Postgres - Codigos de Erros
Postgres - Codigos de Erros
http://pgdocptbr.sourceforge.net/pg80/errcodes-appendix.html
http://pgdocptbr.sourceforge.net/pg80/errcodes-appendix.html
Código de erro | Significado |
---|---|
Class 00 | Successful Completion |
00000 | SUCCESSFUL COMPLETION |
Class 01 | Warning |
01000 | WARNING |
0100C | DYNAMIC RESULT SETS RETURNED |
01008 | IMPLICIT ZERO BIT PADDING |
01003 | NULL VALUE ELIMINATED IN SET FUNCTION |
01007 | PRIVILEGE NOT GRANTED |
01006 | PRIVILEGE NOT REVOKED |
01004 | STRING DATA RIGHT TRUNCATION |
01P01 | DEPRECATED FEATURE |
Class 02 | No Data — this is also a warning class per SQL:1999 |
02000 | NO DATA |
02001 | NO ADDITIONAL DYNAMIC RESULT SETS RETURNED |
Class 03 | SQL Statement Not Yet Complete |
03000 | SQL STATEMENT NOT YET COMPLETE |
Class 08 | Connection Exception |
08000 | CONNECTION EXCEPTION |
08003 | CONNECTION DOES NOT EXIST |
08006 | CONNECTION FAILURE |
08001 | SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION |
08004 | SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION |
08007 | TRANSACTION RESOLUTION UNKNOWN |
08P01 | PROTOCOL VIOLATION |
Class 09 | Triggered Action Exception |
09000 | TRIGGERED ACTION EXCEPTION |
Class 0A | Feature Not Supported |
0A000 | FEATURE NOT SUPPORTED |
Class 0B | Invalid Transaction Initiation |
0B000 | INVALID TRANSACTION INITIATION |
Class 0F | Locator Exception |
0F000 | LOCATOR EXCEPTION |
0F001 | INVALID LOCATOR SPECIFICATION |
Class 0L | Invalid Grantor |
0L000 | INVALID GRANTOR |
0LP01 | INVALID GRANT OPERATION |
Class 0P | Invalid Role Specification |
0P000 | INVALID ROLE SPECIFICATION |
Class 21 | Cardinality Violation |
21000 | CARDINALITY VIOLATION |
Class 22 | Data Exception |
22000 | DATA EXCEPTION |
2202E | ARRAY SUBSCRIPT ERROR |
22021 | CHARACTER NOT IN REPERTOIRE |
22008 | DATETIME FIELD OVERFLOW |
22012 | DIVISION BY ZERO |
22005 | ERROR IN ASSIGNMENT |
2200B | ESCAPE CHARACTER CONFLICT |
22022 | INDICATOR OVERFLOW |
22015 | INTERVAL FIELD OVERFLOW |
2201E | INVALID ARGUMENT FOR LOGARITHM |
2201F | INVALID ARGUMENT FOR POWER FUNCTION |
2201G | INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION |
22018 | INVALID CHARACTER VALUE FOR CAST |
22007 | INVALID DATETIME FORMAT |
22019 | INVALID ESCAPE CHARACTER |
2200D | INVALID ESCAPE OCTET |
22025 | INVALID ESCAPE SEQUENCE |
22010 | INVALID INDICATOR PARAMETER VALUE |
22020 | INVALID LIMIT VALUE |
22023 | INVALID PARAMETER VALUE |
2201B | INVALID REGULAR EXPRESSION |
22009 | INVALID TIME ZONE DISPLACEMENT VALUE |
2200C | INVALID USE OF ESCAPE CHARACTER |
2200G | MOST SPECIFIC TYPE MISMATCH |
22004 | NULL VALUE NOT ALLOWED |
22002 | NULL VALUE NO INDICATOR PARAMETER |
22003 | NUMERIC VALUE OUT OF RANGE |
22026 | STRING DATA LENGTH MISMATCH |
22001 | STRING DATA RIGHT TRUNCATION |
22011 | SUBSTRING ERROR |
22027 | TRIM ERROR |
22024 | UNTERMINATED C STRING |
2200F | ZERO LENGTH CHARACTER STRING |
22P01 | FLOATING POINT EXCEPTION |
22P02 | INVALID TEXT REPRESENTATION |
22P03 | INVALID BINARY REPRESENTATION |
22P04 | BAD COPY FILE FORMAT |
22P05 | UNTRANSLATABLE CHARACTER |
Class 23 | Integrity Constraint Violation |
23000 | INTEGRITY CONSTRAINT VIOLATION |
23001 | RESTRICT VIOLATION |
23502 | NOT NULL VIOLATION |
23503 | FOREIGN KEY VIOLATION |
23505 | UNIQUE VIOLATION |
23514 | CHECK VIOLATION |
Class 24 | Invalid Cursor State |
24000 | INVALID CURSOR STATE |
Class 25 | Invalid Transaction State |
25000 | INVALID TRANSACTION STATE |
25001 | ACTIVE SQL TRANSACTION |
25002 | BRANCH TRANSACTION ALREADY ACTIVE |
25008 | HELD CURSOR REQUIRES SAME ISOLATION LEVEL |
25003 | INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION |
25004 | INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION |
25005 | NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION |
25006 | READ ONLY SQL TRANSACTION |
25007 | SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED |
25P01 | NO ACTIVE SQL TRANSACTION |
25P02 | IN FAILED SQL TRANSACTION |
Class 26 | Invalid SQL Statement Name |
26000 | INVALID SQL STATEMENT NAME |
Class 27 | Triggered Data Change Violation |
27000 | TRIGGERED DATA CHANGE VIOLATION |
Class 28 | Invalid Authorization Specification |
28000 | INVALID AUTHORIZATION SPECIFICATION |
Class 2B | Dependent Privilege Descriptors Still Exist |
2B000 | DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST |
2BP01 | DEPENDENT OBJECTS STILL EXIST |
Class 2D | Invalid Transaction Termination |
2D000 | INVALID TRANSACTION TERMINATION |
Class 2F | SQL Routine Exception |
2F000 | SQL ROUTINE EXCEPTION |
2F005 | FUNCTION EXECUTED NO RETURN STATEMENT |
2F002 | MODIFYING SQL DATA NOT PERMITTED |
2F003 | PROHIBITED SQL STATEMENT ATTEMPTED |
2F004 | READING SQL DATA NOT PERMITTED |
Class 34 | Invalid Cursor Name |
34000 | INVALID CURSOR NAME |
Class 38 | External Routine Exception |
38000 | EXTERNAL ROUTINE EXCEPTION |
38001 | CONTAINING SQL NOT PERMITTED |
38002 | MODIFYING SQL DATA NOT PERMITTED |
38003 | PROHIBITED SQL STATEMENT ATTEMPTED |
38004 | READING SQL DATA NOT PERMITTED |
Class 39 | External Routine Invocation Exception |
39000 | EXTERNAL ROUTINE INVOCATION EXCEPTION |
39001 | INVALID SQLSTATE RETURNED |
39004 | NULL VALUE NOT ALLOWED |
39P01 | TRIGGER PROTOCOL VIOLATED |
39P02 | SRF PROTOCOL VIOLATED |
Class 3B | Savepoint Exception |
3B000 | SAVEPOINT EXCEPTION |
3B001 | INVALID SAVEPOINT SPECIFICATION |
Class 3D | Invalid Catalog Name |
3D000 | INVALID CATALOG NAME |
Class 3F | Invalid Schema Name |
3F000 | INVALID SCHEMA NAME |
Class 40 | Transaction Rollback |
40000 | TRANSACTION ROLLBACK |
40002 | TRANSACTION INTEGRITY CONSTRAINT VIOLATION |
40001 | SERIALIZATION FAILURE |
40003 | STATEMENT COMPLETION UNKNOWN |
40P01 | DEADLOCK DETECTED |
Class 42 | Syntax Error or Access Rule Violation |
42000 | SYNTAX ERROR OR ACCESS RULE VIOLATION |
42601 | SYNTAX ERROR |
42501 | INSUFFICIENT PRIVILEGE |
42846 | CANNOT COERCE |
42803 | GROUPING ERROR |
42830 | INVALID FOREIGN KEY |
42602 | INVALID NAME |
42622 | NAME TOO LONG |
42939 | RESERVED NAME |
42804 | DATATYPE MISMATCH |
42P18 | INDETERMINATE DATATYPE |
42809 | WRONG OBJECT TYPE |
42703 | UNDEFINED COLUMN |
42883 | UNDEFINED FUNCTION |
42P01 | UNDEFINED TABLE |
42P02 | UNDEFINED PARAMETER |
42704 | UNDEFINED OBJECT |
42701 | DUPLICATE COLUMN |
42P03 | DUPLICATE CURSOR |
42P04 | DUPLICATE DATABASE |
42723 | DUPLICATE FUNCTION |
42P05 | DUPLICATE PREPARED STATEMENT |
42P06 | DUPLICATE SCHEMA |
42P07 | DUPLICATE TABLE |
42712 | DUPLICATE ALIAS |
42710 | DUPLICATE OBJECT |
42702 | AMBIGUOUS COLUMN |
42725 | AMBIGUOUS FUNCTION |
42P08 | AMBIGUOUS PARAMETER |
42P09 | AMBIGUOUS ALIAS |
42P10 | INVALID COLUMN REFERENCE |
42611 | INVALID COLUMN DEFINITION |
42P11 | INVALID CURSOR DEFINITION |
42P12 | INVALID DATABASE DEFINITION |
42P13 | INVALID FUNCTION DEFINITION |
42P14 | INVALID PREPARED STATEMENT DEFINITION |
42P15 | INVALID SCHEMA DEFINITION |
42P16 | INVALID TABLE DEFINITION |
42P17 | INVALID OBJECT DEFINITION |
Class 44 | WITH CHECK OPTION Violation |
44000 | WITH CHECK OPTION VIOLATION |
Class 53 | Insufficient Resources |
53000 | INSUFFICIENT RESOURCES |
53100 | DISK FULL |
53200 | OUT OF MEMORY |
53300 | TOO MANY CONNECTIONS |
Class 54 | Program Limit Exceeded |
54000 | PROGRAM LIMIT EXCEEDED |
54001 | STATEMENT TOO COMPLEX |
54011 | TOO MANY COLUMNS |
54023 | TOO MANY ARGUMENTS |
Class 55 | Object Not In Prerequisite State |
55000 | OBJECT NOT IN PREREQUISITE STATE |
55006 | OBJECT IN USE |
55P02 | CANT CHANGE RUNTIME PARAM |
55P03 | LOCK NOT AVAILABLE |
Class 57 | Operator Intervention |
57000 | OPERATOR INTERVENTION |
57014 | QUERY CANCELED |
57P01 | ADMIN SHUTDOWN |
57P02 | CRASH SHUTDOWN |
57P03 | CANNOT CONNECT NOW |
Class 58 | System Error (errors external to PostgreSQL itself) |
58030 | IO ERROR |
58P01 | UNDEFINED FILE |
58P02 | DUPLICATE FILE |
Class F0 | Configuration File Error |
F0000 | CONFIG FILE ERROR |
F0001 | LOCK FILE EXISTS |
Class P0 | PL/pgSQL Error |
P0000 | PLPGSQL ERROR |
P0001 | RAISE EXCEPTION |
Class XX | Internal Error |
XX000 | INTERNAL ERROR |
XX001 | DATA CORRUPTED |
XX002 | INDEX CORRUPTED |
Assinar:
Postagens (Atom)