|
More site info...
Database Development | Forum profile
|
|
Forum profile page for Database Development on http://www.vbforums.com.
This report page is the aggregated overview from a single forum: Database Development, located on the Message Board at http://www.vbforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Database Development" on the Message Board at http://www.vbforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Database Development:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
116
|
463
|
1,302
|
|
Post:
|
370
|
1,705
|
4,828
|
|
|
Database Development Posting activity graph:
|
Top authors during last week:
user's latest post:
displaying a table's column...
Published (2009-11-13 09:13:00)
One way is to open a recordset containing all columns, but no rows: Code: Dim strSQL as String Dim intField as Integer Dim objRS as ADODB.Recordset strSQL = "SELECT * FROM Table1 WHERE False" objRS.Open strSQL, objCN , adOpenForwardOnly, adLockReadOnly, adCmdText For intField = 0 To objRS.Fields.Count -1 MsgBox objRS.Fields(intField).Name Next intField objRS.Close Set objRS = Nothing Another is to use OpenSchema. You can see...
user's latest post:
Trying to learn some database...
Published (2009-11-12 22:33:00)
Because it is not the job of the database to throw DML "events/notifications" to the front end so they can update their copies of the data. Following your logic that would be a performance and synchronization nightmare; for each DML a user does all other users (possibly hundreds) will have to be notified by the database despite the fact that changes have not yet been COMMITed and all other users are in turn making their own...
user's latest post:
displaying a table's column...
Published (2009-11-13 10:57:00)
Querying the data dictionary is helpful, if you're using Oracle. sql Code: SELECT column_name FROM dba_tab_columns WHERE table_name = 'TABLE'
user's latest post:
[RESOLVED] PROBLEM WITH sql and...
Published (2009-11-13 06:34:00)
Quote: SQL = "Select * From " & T_TABELLE & " WHERE TIPO_UO_1='21' AND DENDVAL= '" & Format(DATA, "yyyy/mm/dd") & "' AND MERCATO_PTF='F' and not uo_1='nc'" I think it is correct...
user's latest post:
[RESOLVED] Stored procedure...
Published (2009-11-12 13:28:00)
Quote: Originally Posted by techgnome if running it from something like Query Analyzer or SQL Management Studio, yes... if from code, then it's a little more complicated. And for that I suggest you read the Database FAQ And Tutorial thread . -tg Thank you! The thread is now solved!
user's latest post:
Help with SQL query
Published (2009-11-13 21:11:00)
Quote: Originally Posted by computerman What do you mean by that? Computerman Have a look at this FAQ article.
user's latest post:
[SQL 2000]Composite key...
Published (2009-11-13 20:24:00)
I'm fairly sure what you're trying to do is not possible. I think you'd have to add an extra identity column to act as PK for the table and then make your two FK columns a unique key for the table, which I believe will allow nulls.
user's latest post:
[RESOLVED] Stored procedure...
Published (2009-11-12 12:40:00)
if running it from something like Query Analyzer or SQL Management Studio, yes... if from code, then it's a little more complicated. And for that I suggest you read the Database FAQ And Tutorial thread . -tg
|
|
|
|
Latest active threads on Database Development::
Started 4 days, 3 hours ago (2009-11-11 07:08:00)
by Hack
Don't use the datagrid.
For what you need to do, I would suggest moving to the ListView.
Started 2 days, 12 hours ago (2009-11-12 22:33:00)
by leinad31
Because it is not the job of the database to throw DML "events/notifications" to the front end so they can update their copies of the data.
Following your logic that would be a performance and synchronization nightmare; for each DML a user does all other users (possibly hundreds) will have to be notified by the database despite the fact that changes have not yet been COMMITed and all other ...
Started 2 weeks, 5 days ago (2009-10-26 19:20:00)
by GDOG34
Ok, My game has a board in it and what the code does is load the save state from a database and on the board and on the board if there is a "0" it means the question is used, if it is a "1" it means the question is still there. Im having problems because it is not loadingin the save states. The Board Is Like Follows:
X X X X X < Cat51...
Started 2 days, 2 hours ago (2009-11-13 08:54:00)
by Hack
Moved From The CodeBank (which is for posting finished code to be shared as opposed to asking questions)
Started 1 day, 18 hours ago (2009-11-13 16:19:00)
by GaryMazzone
strSQL = "Select RoomNo,RoomType "
strSQL &= "From Rooms "
strSQL &= "Where "
strSQL &= " RoomType = txtRoomType AND "
strSQL &= " Status = 'Avail' AND "
strSQL &= " Date Beteen '" & Me.txtArriveDate.Text &"' AND '" & Me.txtDepartDate & "'"
Started 1 day, 14 hours ago (2009-11-13 20:24:00)
by jmcilhinney
I'm fairly sure what you're trying to do is not possible. I think you'd have to add an extra identity column to act as PK for the table and then make your two FK columns a unique key for the table, which I believe will allow nulls.
Started 1 day, 22 hours ago (2009-11-13 12:18:00)
by sesproul
No Responses, so I just bit the Bullet and wrote a routine to open a Recordset against the first DB, and then build a INSERT statment into the second.
LEARNED an interesting thing about MYSQL.
the LINUX version is case sensitive, and the windows version is Case insensitive.
So I changed all tables to be consistent with Lower case names. Now everything works fine.
Steve
Started 2 days, 1 hour ago (2009-11-13 09:02:00)
by si_the_geek
There are several ways, but like with most things to do with database related code, which one(s) are valid depend on which connection technology you are using - such as ADO code/ADO control/DAO control/...
Started 2 days, 21 hours ago (2009-11-12 13:41:00)
by rjv_rnjn
Not very clear on what you want to do. Is your database going to be on the same machine as the application? In that case all you'll need to do is the connection string setting to point to the local machine instance.
Started 1 month, 2 weeks ago (2009-09-30 05:27:00)
by rpool
VB Run Time error 3265,3704 ADODB. Recordset
I have problem
I write this program name: txt to mdb
but now,
(Q1) rs!xxxxx VB Run Time error 3265 Item not found ?
(Q2) rs!AddNew "run-time error 3704, operation is not allowed when the object is closed"
I try List6.Additem to check and verify Doing what, is fine. ...
|
|
Hot threads for last week on Database Development::
Started 2 days, 6 hours ago (2009-11-13 04:23:00)
by akhileshbc
Why don't you use it like this:
Code:
dim DATA As Date
DATA = cdate("31/12/2050")
Started 4 days, 3 hours ago (2009-11-11 07:08:00)
by Hack
Don't use the datagrid.
For what you need to do, I would suggest moving to the ListView.
Started 1 week, 1 day ago (2009-11-07 02:18:00)
by vb5prgrmr
To answer your question you should look at the documentation about specific databases and then ask specific questions concerning that specific DBMS.
for a decent listing of databases scroll down to examples in this wikipedia listing...
http://en.wikipedia.org/wiki/Database_management_s ystem
Good Luck
Started 2 days, 11 hours ago (2009-11-12 23:26:00)
by akhileshbc
will this help you....
Code:
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= " & App.Path & "\db1.mdb;Persist Security Info=False;Jet OLEDB:Database Password=pwd;"
cn.Open
Set rs = New ADODB. Recordset
rs.Open "SELECT * FROM Table1 ", cn, adOpenForwardOnly, adLockReadOnly
While Not rs.EOF
if left(rs....
Started 1 week, 5 days ago (2009-11-03 09:36:00)
by techgnome
This should at least get you moving in the right direction.
http://www.vbforums.com/showthread.php?t=337051
-tg
Started 4 days, 5 hours ago (2009-11-11 05:12:00)
by si_the_geek
Your question has nothing whatsoever to do with a connection string (which contains info about where the database is, etc), it is about an SQL statement (which returns/uses data).
The problem is that your SQL statement (whether in VB or not) is not valid, because you have not put the value in correctly. For an explanation and examples of delimiters to use around values within SQL statements, ...
Started 3 days, 21 hours ago (2009-11-11 13:46:00)
by abhijit
CInt(cboID.Text)
ETA: Also if this is an integer, you don't need to enclose it in SINGLE QUOTES.
Started 4 days, 20 hours ago (2009-11-10 14:10:00)
by si_the_geek
Thread moved to ' Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)
Started 1 week ago (2009-11-07 11:19:00)
by si_the_geek
Welcome to VBForums
You have picked the correct forum, as this is the one where SQL based questions belong. Other Access based questions belong in the Office Development forum (not the VB6 forum, because Access etc use VBA rather than VB).
As to the problem, you seem to be missing a space at the end of this line:
Code:
sSQL = "TRANSFORM Count(Referrals.Age) AS CountOfAg e "...
Started 1 week ago (2009-11-08 00:11:00)
by lye85
|
|
Size: 105 bytes
