Search results for query: *

Thanks for the ideas I'll do some more reading and take on board what you guys have suggested. I don't have the time to redesign\re-code the system at the moment so I was trying to just do an a like for like change and we will then review it to fit with our new ICT strategy. I'll update this...

I have a visual foxpro system that I am migrating to a sql server database. The system uses pessimistic record which I would like to replicate with the connections to SQL server. I connect to the database using ODBC authenticating via active directory. The steps of processing that usually...

I have a string of text produced from a proprietary system that contains several values that I am interested in. Ideally I would have liked to be able to get this as individual field values however the suppliers say they can't produce this data. Ridiculous, I know but I can't do anything about...

Many thanks Borislav, i spent ages pulling my hair out on this one, the bit of hair I have. It was trying to accommodate the double single quote that caught me out. Looks like I've learnt my one new thing for today! It also warrants a star. Mark Davies Warwickshire County Council

I have the code below which I am going to use in the setup of databases. It works but I want to parametrise the database name in the "if exists select * ..." statement. I am very new to SQL Server and have tried to find examples of basic selects using the "EXEC" command with where clauses that...

I stripped out some of the unnecessary stuff from the file DSN and got it down to just the following. It was the trusted_connection that made the difference. The parts I removed were the WSID, ID and DESCRIPTION lcDSNLess = "DRIVER=SQL...

Cheers Mike, I have looked at that and just tried adding the elements that made sense. I'll try it with all the settings and see if that works. Mark Davies Warwickshire County Council

I have a SQL server database that has been set up to be accessed through active directory. To access it I have created a SQL Server ODBC DSN using the wizard in the ODBC manager and can connect with the following code: STORE SQLSTRINGCONNECT('dsn=saw_live') TO gnConnHandle IF gnConnHandle <...

Cheers for the responses people. I'll have to find some time to look at this and if I get it working I'll post back what I did and some code. Mark Davies Warwickshire County Council

Is there any way to have the user enter a password and check it against their password in active directory? We used to have a library called GPLIB that did this with NOVELL and are looking for something similar. I've looked at the posts referring to windows passwords but these don't seem...

A simple count and group would sort this unless I am missing something: EG Select status, count(status) from table group by status Mark Davies Warwickshire County Council

Tried that PHV and it works a treat. Mark Davies Warwickshire County Council

Thanks, will check that out and see if I can get it too work. I really do hate access sometimes. Makes easy things very hard to achieve. Mark Davies Warwickshire County Council

Database background: ==================== The database is currently split into the data as one database and the forms, queries and reports in another database. Both databases sit on a file server and are used by multiple users. Problem: ======== I want to create a form that allows users to...

I've not written the actual database so was just making the example up based on what it's doing. I have since knocked up a simple example. The code wasn't 100% accurate, I meant it as an example of what it should be the proper query is as below: SELECT inputdata.* FROM inputdata WHERE...

I have an issue with using an IN keyword in a where cluase of a query. It seems to work if the values I look for are hardcoded but not if I try and take them from a textbox on a form. If I create a query using an IN keyword in the from with hardcoded sites the query will return data (see...

I came up with a solution that might work. I am going to create a temporary table when the application starts and write the name of all public arrays created to it. When the error handler is triggered check for the existence of the table and loop through the variables releasing them one by...

I have an old system that uses the "display memory" command to send the contents of the memory to a text file. However, there are several large arrays and after the text file is created the system errors with a General Protection Fault. I know I can close these publick variables down with a...

We're just in a process of installing some new financial applications and they can use one of two methods to connect. Both of which roll up the application oracle connection into the application so there is no oracle install required on the cleint. One of these uses the easyconnect from...

vb5prgrmr, the tread you pointed me to opens an object and waits for a specified period. I actually want to wait indefinitely so unless I put in a massive millisecond pause value its not actually going to achieve what I want. I have two solutions now: Solution 1 basically opens an ie object...