CREATE TABLE [testBigInt] (
	[bigint] [bigint] NULL 
) ON [PRIMARY]
GO

close databases all

local lcConnString, lnConnection, ;
	loMyCAD as CursorAdapter, ;
	laErrors[ 1 ]
text to lcConnString noshow pretext  15 
	Driver=SQL Server;
	SERVER=beaver\l00;
	DATABASE=Kot_MyTest;
	uid=kot;
	pwd=;
endtext	
lnConnection = sqlstringconnect(lcConnString)
if lnConnection<= 0 
   messagebox('не подцепился')
   return 
endif

loMyCAD = createobject('CursorAdapter')
with loMyCAD
	.Alias              = 'MyAlias'
	.DataSourceType     = 'ODBC'
	.DataSource         = lnConnection
	.SelectCmd          = "select * from testBigInt"
	.Tables             = 'testBigInt'
	.BufferModeOverride =  5 
	.cursorschema       = "bigInt c(16)"
	.UpdatableFieldList = 'bigInt'
	.updateNameList     = 'bigInt testBigInt.bigInt'
	if .CursorFill()
		select MyAlias
		append blank
		replace bigint with '1234567890123456'
		if !tableupdate(.t.,.t.,.Alias)
			aerror(laErrors)
		    messagebox(laErrors[ 2 ])
		endif
	else
		aerror(laErrors)
		messagebox(laErrors[ 2 ])
	endif .CursorFill()
endwith

set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigInt (bigInt) VALUES (@P1 )', N'@P1 varchar(20)', '1234567890123456    '
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go

CREATE TABLE [testBigDate] (
	[BigDate] [datetime] NULL 
) ON [PRIMARY]
GO

close databases all

local lcConnString, lnConnection, ;
	loMyCAD as CursorAdapter, ;
	laErrors[ 1 ]
text to lcConnString noshow pretext  15 
	Driver=SQL Server;
	SERVER=beaver\l00;
	DATABASE=Kot_MyTest;
	uid=kot;
	pwd=;
endtext	
lnConnection = sqlstringconnect(lcConnString)
if lnConnection<= 0 
   messagebox('не подцепился')
   return 
endif

loMyCAD = createobject('CursorAdapter')
with loMyCAD
	.Alias              = 'MyAlias'
	.DataSourceType     = 'ODBC'
	.DataSource         = lnConnection
	.SelectCmd          = "select * from testBigDate"
	.Tables             = 'testBigDate'
	.BufferModeOverride =  5 
	.cursorschema       = "bigDate d(8)"
	.UpdatableFieldList = 'bigDate'
	.updateNameList     = 'bigDate testBigDate.bigDate'
	if .CursorFill()
		for i= 1  to  10 
		   insert into MyAlias values (date())
		endfor
		select MyAlias
		brow
		if !tableupdate(.t.,.t.,.Alias)
			aerror(laErrors)
		    messagebox(laErrors[ 2 ])
		endif
	else
		aerror(laErrors)
		messagebox(laErrors[ 2 ])
	endif .CursorFill()
endwith

select  504 ,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset'))
go
select USER_NAME() select usertype,type,name from systypes where usertype>= 257 
go
exec sp_datatype_info  1 
go
exec sp_datatype_info  12 
go
exec sp_datatype_info - 2 
go
exec sp_datatype_info - 3 
go

-- вот селект
select * from testBigDate
go

-- а это после команды таблапдейт
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Jan 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Jan 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Jan 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go
set implicit_transactions on 
go
exec sp_executesql N'INSERT INTO testBigDate (bigDate) VALUES (@P1 )', N'@P1 datetime', 'Dec 12 2006 12:00:00:000AM'
go
IF @@TRANCOUNT >  0  COMMIT TRAN
go

вы о чём тут вообще