vba:access:classes:sqlscript
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
vba:access:classes:sqlscript [24.10.2016 11:57:05] yaslaw |
vba:access:classes:sqlscript [18.01.2017 10:24:56] yaslaw |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| <const> | <const> | ||
| - | version=1.5.0 | + | version=1.5.2 |
| - | vdate=21.06.2016 | + | vdate=18.01.2017 |
| 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
