Search results for query: *

Hi, I think, the simple way to do this is next: 1. Open the recordset with some query: Query = "SELECT BLA,BLA,BLA FROM ENYTABLE" rsRecordset open, connection,adOpenDinamic, adLockOptimistic, adCmdUnknown 2. you will get in rsRecordset all record from this table. In case, that you will show...

I know about this function Cdbl (and other functions), but I have problem, while some regional settings have different type (comma is sometimes like separator, sometimes like digit grouping symbol). I need to have "little function", which "translate" a reading string into real double format...

Hi, What is the best way to convert data from ASCII file (numeric) into currency or float (and write him into SQL table)? Some user have different regional settings (point, comma, ...)? Please, I need some tip.... Tnx, DaT

Hi, I have a little stupid problem. I need transfer data from txt file (using visual basic application) direct to SQL table. The Date field in TXT table is in yymmdd format (for example: 051103). When I write into SQL data over ADO and convert date field into next format: '11/03/2005', I get in...

Hi, I have a little stupid problem. I need transfer data from txt file (using visual basic application) direct to SQL table. The Date field in TXT table is in yymmdd format (for example: 051103). When I write into SQL data over ADO and convert date field into next format: '11/03/2005', I get in...

Thanks, if it's this only Solution, i will make this for all tables. I was expected, there will be easy way to solve this... Lp,DaT

Hi, i have realy silly problem. I create database in MS Sql server with wrong collation. I have to many tables in database; all tables are created with wrong collation. Have somebody idea how to change collation in all tables, not to manual changing fields in all tables? Please, help me, my...

Hi, i have realy silly problem. I create database in MS Sql server with wrong collation. I have to many tables in database; all tables are created with wrong collation. Have somebody idea how to change collation in all tables, not to manual changing fields in all tables? Please, help me, my...

Hallo. I have a little problem in MS Sql server. How cann i check when temporary table exist? I create more temp tables (create table #test_table ...) under some Sql connection; how cann i know, that this table not exist in connection?! Please,help! DaT

Hallo, i think the problem is here: conn = rptPrint.LogOnServer("p2ssql.dll", "SRVnme", "DBnme", "sa", "") The system could not connect to p2ssql.dll; try give a full path & file name - like this: DllName = "c:\winnt\system32\p2ssql.dll" conn = rptPrint.LogOnServer(DllName, "SRVnme"...

Hallo, in case of your question, i will suggest you next: Try with two ado recordsets Set ConAcces = "DNS=... here put the name of DATAbaseconnection" Quiry = "SELECT x, sum(amount) as somefield FROM SampleTable Group by x order by x" rsAdo1.open quiry, ConAccess Quiry = "select * from...

Thanks, i'm using DTS for datatransfer betwen two SQL Server, but in this case, (this is a small application writen for one of my customer) i need to use this application to transfare data from one server to another. How shuld i ping (or check) from VB application another server? Have you some...

Hallo, i need help. I have a writen a simple VB aplication to replicate a recordset from one server to another. I use ODBC connect to all servers. It's possible to geth information from the Server before i have open a connection to this server. In case, that server is not accesible, i geth...

Tnx, man, for this, but have you a idea where to get 3rd party grid (not Dbflex grid). I think flex grid will be to slow or not so usefull to use. Lp,DaT

Hallo, this is very simple (here is a sample): Quiry = "SELECT * FROM XXTABLE" rsIps.Open Quiry, CnIps, adOpenStatic, adLockReadOnly, adCmdUnknown lstVrsta.Clear Do While Not rsIps.EOF DoEvents LstVrsta.AddItem rsIps("DS02VRSTA") & Space(1) &...

Hi, i need some sample, how to input a checkbox into datagrid. I use VB 6 wiht Datagrid control to get a recordsed from MS SQL Server. i need to give a user posibility to check some rows, and then, i will make some action only for checked rows. Have a somebody a idea, how to handle this...