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...

...depending upon the types of indes you have on the table. To test this I wrote a simple statement in SQL management studio below: SELECT * FROM [saw_test].[dbo].[client] WITH (ROWLOCK NOWAIT) WHERE client_id = 1 Index is CLUSTERED called pk_client_id on the field client_id I then opened...

...characters? This code works returning 694572.12: SELECT REGEXP_REPLACE (REGEXP_REPLACE (payment_data, '( ){2,}', ' '), '^.*Overall Total ([[:digit:]]+\.[[:digit:]]+).*$', '\1', 1, 0...

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

...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...

...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 (((inputdata.sitename) In ([Forms]![Form1]![txtwhere]))); This will only work if the value is a single value and has no...

...on a form. If I create a query using an IN keyword in the from with hardcoded sites the query will return data (see QUERY1) QUERY1 SELECT * FROM inputdata WHERE sitename in("site 1","site2"); If I create a form (FORM1) with a textbox (TXTWHERE) with the value: "site 1","site2". Then...

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...

...down with a "release x" command where x is the name of the variable. The arrays are all prefixed "ga" so I hoped to just use a "release all like ga*". This doesn't work because release all only works on variables that are private. I am stuck for ideas now, anyone suggest a way of...

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...