|
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:
|
136
|
436
|
1,317
|
|
Post:
|
396
|
1,511
|
4,624
|
|
|
Database Development Posting activity graph:
|
Top authors during last week:
user's latest post:
ms access datatype null values
Published (2009-11-27 07:53:00)
The problem is that you aren't trying to set the field value to a Date, or to Null - but to an empty string instead (which cannot be stored in a Date field). One way to deal with it is to explicitly set it to Null when the textbox is empty, eg: Code: If TxtDA1.Text = "" Then rs!Date_of_Action1 = TxtDA1.Text Else rs!Date_of_Action1 = Null End If
user's latest post:
[RESOLVED] How to alter the...
Published (2009-11-24 14:51:00)
I am going to mark this thread "Resolved" and am most grateful to dee-u for having pointed me towards ADOX as the route to a solution, This directed me to a search and I found MS articles ms676514 and aa164917 to be very helpful. My code above posted is based upon these. I can now, to the extent that my simple needs require, automate MS Access from VB code, creating a new Table of my defined characteristics or delete an...
user's latest post:
A little help with my database...
Published (2009-11-23 21:42:00)
Details that appear in the receipt/invoice and has to be maintained separately per internal revenue and audit requirements (think point in time snapshot), e.g. even if patron name was changed in reference table, recorded name in transaction table must still be the same as in printout/hardcopy (unless you will maintain FK in patron table, name change results in new patron record), VAT and other rates (fines, etc) could also have changed hence...
user's latest post:
what is downLoad
Published (2009-11-23 15:19:00)
Quote: Originally Posted by make me rain with vb6 when i am down loading any files or demo applications i really surprise what code is running behind the screen to save the file on to my disc can any one please tell me the code i would like to use the same in my data base applications Are you referring to the animated progress bar?
user's latest post:
what is downLoad
Published (2009-11-23 21:25:00)
no is it help full for me in this connection !
user's latest post:
ms access datatype null values
Published (2009-11-26 22:27:00)
Thanks for the reply, Here's my code in updating database rs.addNew rs!Date_of_Action1 = TxtDA1.Text rs!Action2 = CboA2.Text rs!Date_of_Action2 = TxtDA2.Text rs!Action3 = CboA3.Text rs!Date_of_Action3 = TxtDA3.Text rs.Update Note: Datatype of Date_of_Action1,Date_of_Action2,and Date_of_Action3 are DATE/TIME Here's my problem If txtDA2, is empty value the error will occur "Datatype conversion error 3421", i try set...
user's latest post:
[RESOLVED] Using BCP with a query
Published (2009-11-26 01:36:00)
looks like i had miss read your query...this is what i have done to mimic exactly what you did and its now working. thanks a lot hey. --AND HQ..PurchaseOrder.DateCreated >='''+Convert(varchar,@StartDate,120)+''' AND HQ..PurchaseOrder.DateCreated <='''+Convert(varchar,@EndDate,120)+''' GROUP BY...
user's latest post:
A problem when launching the...
Published (2009-11-23 10:53:00)
Write some code to retrieve all the data from the previous database, when the user updates to the new version...
user's latest post:
[RESOLVED] Doubt about UNION...
Published (2009-11-26 10:48:00)
Add a Group By clause to both Select statements in the Union. Code: ... as totalNumber from Invoices Group By user
|
|
|
|
Latest active threads on Database Development::
Started 1 day, 7 hours ago (2009-11-28 15:17:00)
by si_the_geek
If you want to do the conversion in the SQL statement, you need to list all the fields.
The alternative is to do something in your VB code while using the data.
Started 1 day, 14 hours ago (2009-11-28 08:25:00)
by gibra
First, open a 'empty' ADODB. Recordset:
Code:
rs.Open "SELECT * FROM tabel WHERE 1=0", CN, , adCmdText
Next process Field collections to get all properties you want:
Code:
Dim i as long
For i = 0 to rs.Fields.Count -1
Debug.Print rs.Fields(i).Name
Debug.Print rs.Fields(i).Type
Debug.Print rs.Fields(i).DefinedSize
' ...
Next i
Alternately, you...
Started 1 day, 21 hours ago (2009-11-28 01:53:00)
by akhileshbc
Use the following SQL code:
"SELECT * FROM tablename WHERE uniqueid = " & txtID.text & " "
Started 1 day, 10 hours ago (2009-11-28 12:45:00)
by si_the_geek
Post moved from this CodeBank thread , which is not related to the question, to its own thread in our Database Development forum.
Most of the answer to your question is likely to be in our Database Development FAQs/Tutorials (at the top of this forum) , but we can't really tell yet, as you haven't given enough detail for us to be able to tell what part(s) you need help with.
What ...
Started 1 day, 10 hours ago (2009-11-28 12:30:00)
by RunsWithScissors
Can you post your code?
Are you using SQL to perform the file output, or some client code?
Post BOTH.
@@ROWCOUNT returns the number of rows affected in the VERY LAST SQL Operation. If your query is doing anything else after selecting records for file output (or if it is constructed in a way which updates only changed records in the file) then you will get a ROWCOUNT which reflects...
Started 1 day, 11 hours ago (2009-11-28 12:04:00)
by RunsWithScissors
What database are you using?
While the solution will probably logically the same, your approach may be different if you are using MS Access vs, say, SQL Server.
In either case, you will be dealing with Sub-queries. This is one way to do it in SQL Server. This may not be the most efficient way, but it works. This query will Update all of the records with a code of "DUB" to include the ...
Started 2 days, 2 hours ago (2009-11-27 20:38:00)
by Nightwalker83
I'm not sure but check your code to make sure you have used correct spelling!
I noticed you use:
Code:
dacalendar.Fill(dscalendar)
However, I can't find where you are getting dscalendar from? Do you mean dacalendar?
Started 2 days, 15 hours ago (2009-11-27 07:48:00)
by si_the_geek
The benefits of security etc are correct, and actually go a bit further than what you mentioned... for example, the security can be made significantly better because the user does not need any permissions on the tables, but instead only on the SP's that do the work.
There will be at least a small speed improvement due to the reduced network traffic.
I don't have experience of MySQL, but ...
Started 2 days, 13 hours ago (2009-11-27 10:12:00)
by GaryMazzone
Are you doing this in SSMS? though T-SQL? From appliction you wrote?
|
|
Hot threads for last week on Database Development::
Started 1 week, 2 days ago (2009-11-20 21:31:00)
by dee-u
First things first, using a databound control like adodc is a very bad thing in VB6, it is not reliable and tend to give lots of problems.
There should be threads in the FAQ and codebank section for manipulating excel files, have a search.
Started 1 week ago (2009-11-22 07:09:00)
by akhileshbc
Welcome to VBForums.com
Try upgrading to ADO...
Started 5 days, 19 hours ago (2009-11-24 03:27:00)
by ruslannurijev
[RESOLVED] SQL: can't Select date from textBox
Hi there guys/girls!
I want to select(SQL) a date from TextBox but it seems that i type incorrect syntax, couse i get a "Type Mismatch".
The date value in TextBox 100% correct date format, couse this TextBox gets this date value from Calendar on Click action.
I have done ...
Started 2 days, 15 hours ago (2009-11-27 07:48:00)
by si_the_geek
The benefits of security etc are correct, and actually go a bit further than what you mentioned... for example, the security can be made significantly better because the user does not need any permissions on the tables, but instead only on the SP's that do the work.
There will be at least a small speed improvement due to the reduced network traffic.
I don't have experience of MySQL, but ...
Started 4 days, 11 hours ago (2009-11-25 12:05:00)
by GaryMazzone
I think you are stuck with that or with OSQL that will let you supply an output file for the results.
Or SSIS packages
Started 5 days, 8 hours ago (2009-11-24 14:46:00)
by si_the_geek
For an explanation and examples of delimiters to use around values within SQL statements, see the article How do I use values (numbers, strings, dates) in SQL statements? from our Database Development FAQs/Tutorials (at the top of this forum)
Quote:
Search_Date is a DTPicker value formatted as dtpShortDate, which how it is saved in the database....
Started 3 days, 12 hours ago (2009-11-26 10:17:00)
by yaeko
[RESOLVED] Doubt about UNION query (Access)
Hi
EXAMPLE
Quote:
Select user,sum(total) as TotalSales,sum(idInvoice) as totalNumber from Invoices
Returns :
John | 5000 | 10
Mary | 3540 | 5
Quote:
Select user,sum(total) as ...
Started 4 days ago (2009-11-25 22:24:00)
by rack
You are basically doing a Difference Total (Similar to a Running Total).
Your query works, however each value is ahead 1 row.
Try your query in reverse order.
Code:
SELECT a.*,
a.KMReading - (SELECT TOP 1 b.KMReading FROM ExpenceEntry b WHERE b.KMReading < a.KMReading and b.TruckId=a.truckID ORDER BY b.KMReading DESC) as KRead
FROM ExpenceEntry AS a
ORDER BY 1, ...
Started 5 days, 18 hours ago (2009-11-24 04:53:00)
by dawsonz
SQL: Finding nearest record
Hi,
My program currently connects to my database and the user selects an available user from a list in a datagridview.
However, I'm trying to implement a button that when clicked doesn't need to find an available user but will just automatically assign the nearest user available.
For example...
Started 1 week, 5 days ago (2009-11-17 09:09:00)
by si_the_geek
When designing tables you shouldn't focus on the way it will be displayed/used in the program - you should focus on what data needs to be stored.
So far all we know is that each Day should be able to store a single value (perhaps a boolean), but we don't know what data should be stored for a Week.
|
|
Size: 175 bytes
