Database

Aaaah, the open source profiler has become a commercial product. There's also a profiler included with Sql Server, but it would not be installed for a Sql Express version - that's why I linked an open-source version. You might want to try their trial-version[^]. Alternatively, there's an implementation of a TSql profiler here[^]. Guess I'll be using that one from now on, as I do not like to recommend trial-versions. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

I work in a closed environment and have no applications in third party hands so changing the db password is not an issue. Not sure how I would handle an application at other sites. Even encrypting a connection string would require a hardcoded key somewhere along the line.

Azher.Cybertech wrote: yes i m familiar with join concept. bt i doesn't work for my requirement I'm sure the examples don't work as-is. You'll need to write some Sql to gather the required results :) Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

I am trying to create a UDDT. I know how to do it using "Create Type", but I have also saw some query like I have posted. SignatureNotFoundException

nuts15 wrote: when i click on a link, i should get a list of values from the database into the html page.i am using asp for connectivity. Classic ASP? There are tutorials here[^]. You'd need to learn a server-side language, and how to talk to the database. Meaning, you'll have to learn to program it; there's little chance someone else will post the code - in this case, someone might, as it is part of the basics. If you have a specific question or get stuck, I'll gladly help. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

thenks for ur reply

Hello David Thanks very much for the suggestion The full DB was not as large as I though it would be so just used a full backup, took that home and restored it - all perfect! Thanks Richard

You are welcome. I wasn't, now I am, then I won't be anymore.

Try the following query. SELECT CASE WHEN COUNT(File_Name)=0 THEN 1 ELSE COUNT(File_Name) END as FileName from tblname WHERE (File_Name = @File_Name1)

The fingerprint device is working that way. It is manufactured with that switch button. So if the employee of a given shift was about leaving while the security guys did not change the in/out state of the fingerprint device and that employee put his finger he will have 2 records each with in state and when reading the data this employee considered did not record leaving state. On the other hand, if the employee of a second shift came before his shift start time and the security guys did not switch the device from out state "as they changed the in state to out state at the end of the first shift" and that employee puts his finger so the final result that this employee has 2 records with a leave state. Such matter of wrong records is a case sensitive as the company will depend on the data in calculating the overtime and in salary discount(s). I hope my idea is clear now. The shift 1 and shift 2 begins and ends on 08:00:00 AM - 04:00:00 PM and 06:30:00 PM - 08:00:00 AM on the next day.

This[^] thread seems to have a pretty in depth discussion on the matter. You should check that out. I wasn't, now I am, then I won't be anymore.

thanksssss Richard, Have a nice day!!!!!

Probably the quotes. Remove those and try your query again. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

Thanks for all the replies and suggestions. as it stands the table structure does reveal different AccountNames when queried on different columns (AccountID, CustomerID). And yes, that seems redundant because for case of one record having unique set of AccountID, CustomerID, and AccountName it is obvious. For case of many records with mixed combinations of those 3 columns, I am not guaranteed the AccountName is what I want. I think I'm only concerned if AccountName is not NULL. Thanks!

Keep your column in an numeric format OR convert it manually in numeric format so it dont create destruction.

cjb110 wrote: Is this something to be worried about? Only if you have time to spare. It might hint that additional optimization is possible, but it's not guaranteed that it can be optimized further - it'd be a fun exercise though. You might find this[^] an interesting read to get you started. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

You may use the CRecordset member function GetFieldValue()[^]. There are different overloaded versions of this function which retrieve the values as strings or variants. Use a function which retrieves a variant to get values as C types that correspond to the type stored in the database.

Jörgen Andersson wrote: But you lose time during development, that's for sure. It's one of the more important and underestimated parts of development. It's the reason why Microsoft Access does not solve 'everything'. How much would an inconsistency in the data cost? :rolleyes: Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

When your server is behind the router, then it has a "private" IP address, hasn't it? Then things get complicated. You could create a VPN, such that home and office are virtually in the same network (same range of IP addresses), or you have to configure port forwarding on your router. I cannot give details on how to do that...