Database

Wheres that spoon icon? Never underestimate the power of human stupidity RAH

I know that but what i am asking how that cartesian product is done when " where condition is used in left join"

Rob Philpott wrote: What does this entry in the connection string actually do? Found some good explanation (with usage scenario's) on MSDN[^]; MSDN: In previous versions of the .NET Framework it was possible to simulate non-blocking execution by using asynchronous delegates or the ThreadPool class; however, those solutions simply blocked another thread in the background, making them far from ideal for cases where it is important to avoid blocking threads [...] I are Troll :suss:

Have you looked at connectionstrings.com, that is where we point most inquiries on this subject. Never underestimate the power of human stupidity RAH

Roger Wright wrote: IIRC, a % symbol represented a single arbitrary character Not quite. Apparently there are two standards, one using * the other % for "any string", see here[^]. I have a C#/Access application that works well with % (and not at all with *)but reading that page seems to tell me I should use *, not %. :doh: Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

It was a typo in the example I put just to have an idea how I have the stored procedures lines.

Never mind.I figured it out. I needed brackets for the time field. So it should be : UPDATE tablename SET [time]='12:34' where id=80

Of course, you can always do that, but is a test, in access I can do, and I would like to know how to do in code. Juan Pablo G.C. Overrider Blog

If you have the option, you might consider ensuring that the data all have the same number of digits at end. E.g. use SD01TU09 instead of SD01TU9, or SD01TU009 if there can be three digits. This would mean you don't have to monkey around with substrings. Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

Then you will need to find out what built-in function does string extraction and replace 'mid' with that function name. It probable that the parameters will be different to. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

get your tables from the database put them all in the same dataset create the relationships between the tables set the dataset as the datasource for the DGV [edit] this belongs in the winforms forum, but the above is the way to do it [/edit] Never underestimate the power of human stupidity RAH

Hi I am using MySql, querying it from VB.Net. deStart and dteEnd are VB variables. MySql does not like VB date variables, and so it is best to convert to date in your SQL Query.

I'm not sure about the 2007 version but Access was NOT a multiuser, it worked OK as a mutliuser DB until it didn't and when you asked for support from MS they would stand on the disclaimer that it is NOT multiuser. Definitely use the Express versions (I use MSSQL but that is because of my skill set) and set up a proper client server environment. MSSQL is reasonably easy to set up and very easy to work with. Never underestimate the power of human stupidity RAH

treefirmy wrote: Any rationale for either tactic would be greatly appreciated. I'd open it just before the Connection is used, and close it as soon as I'm done with it; Take a look at tip #3 on Connection Pooling[^]. I are Troll :suss:

How to get an answer to your question[^] I know the language. I've read a book. - _Madmatt

Hi David, Thanks for the reply. I changed the length of the field to 16 and this stopped the error message from displying, the only problem then was the password was showing up as squares. I then changed the length of the field to 80 (5x16=80) sticking with the multiple of 16 rule and it works great now. Thanks for your help with this it lead to me working it out. The reason I was recieving squares I asume is because the encrypted version of the password was larger than 16 and so the full encrypted version of it was too big to fit in the password field, therefore when I tried to decrypt it, it wasn't all there to decrypt and hence the nonsense squares. Thanks again, Mel

Hi, I often use trees and what you essentially needs is the ID and Parent ID for example: ID | ParentID | Name 1 | 0 | A 2 | 1 | AA 3 | 1 | AB 4 | 0 | B 5 | 4 | BA 6 | 4 | BB looks like: [] | -A --AA --AB -B --BA --BB and so on... ... I hope you mean this :doh:

MB_KSU wrote: do you know No idea, especially on Oracle Never underestimate the power of human stupidity RAH

Someday saying thank you... that rated a 5!

There is no answer to this, it depends on many factors I know the language. I've read a book. - _Madmatt