User Tools

Site Tools


vba:access:classes:sqlscript

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
vba:access:classes:sqlscript [24.10.2016 11:57:05]
yaslaw
vba:access:classes:sqlscript [24.10.2016 12:30:47]
yaslaw
Line 1: Line 1:
 <​const>​ <​const>​
-    version=1.5.0  +    version=1.5.1  
-    vdate=21.06.2016+    vdate=24.10.2016
     fname=sqlscript.cls     fname=sqlscript.cls
     ns=%NAMESPACE% ​   ​     ns=%NAMESPACE% ​   ​
Line 351: Line 351:
 End Sub</​code>​ End Sub</​code>​
 <code sql>DROP TABLE [TBL_TEST]; <code sql>DROP TABLE [TBL_TEST];
-CREATE TABLE [TBL_TEST] ([ID] BYTE,​[ITEM_NAME] TEXT(3),​[ITEM_VALUE] ​TEXT(5),​[CREATE_DATE] DATE);+CREATE TABLE [TBL_TEST] ([ID] BYTE,​[ITEM_NAME] TEXT(3),​[ITEM_VALUE] ​DOUBLE,​[CREATE_DATE] DATE);
 INSERT INTO [TBL_TEST] ([ID],​[ITEM_NAME],​[ITEM_VALUE],​[CREATE_DATE]) VALUES (1,'​ABC',​123,#​01-01-1967 00:00:00#); INSERT INTO [TBL_TEST] ([ID],​[ITEM_NAME],​[ITEM_VALUE],​[CREATE_DATE]) VALUES (1,'​ABC',​123,#​01-01-1967 00:00:00#);
 INSERT INTO [TBL_TEST] ([ID],​[ITEM_NAME],​[ITEM_VALUE],​[CREATE_DATE]) VALUES (2,'​DEF',​346.3,#​12-11-2010 00:00:00#); INSERT INTO [TBL_TEST] ([ID],​[ITEM_NAME],​[ITEM_VALUE],​[CREATE_DATE]) VALUES (2,'​DEF',​346.3,#​12-11-2010 00:00:00#);
vba/access/classes/sqlscript.txt · Last modified: 04.09.2019 11:45:59 by yaslaw