Search results for query: *

Hey Guys, Im trying to determin whether a string(between 2 strings) is Numeric or not in sybase sql eg AB12344BC = 1234 is numeric AB12n44BC = 12n44 is NOT numeric Any ideas? Ben p.s Sybase 11

Hey All, Calling all geeks out there, i have a small problem, im linking to a csv file in access via vb DAO(i know i know), but my problem is that when i link, it automatically determines the Type of the fields, eg. what it thinks is a date field becomes a date/time type. I need a way of...

sorry, we are not using userforms(not my choice old excel designed by previous developer), they are embeded ole objects on the sheet. Cheers

Anyone help me with this, How do you setup a tabbing order on a group of combo boxes (or any ole control) Cheers :)

Hey All, How do i use the results from a Union to insert into a tempory table? i thought it should be Select * Into #tmptable from (select a from b union select a from c) Help!!1

Hey All, Ive got 2 tables im trying get some results from Table1 Table2 Fields A B A B 1 2 1 2 3 4 3 4 5 6 being a ms sql server man to get the items not matching between table 1 and 2...

Hey All, Does anyone know how to create/change a range in excel vba. I want to be able to select a range say Col1 and Col3 then change that range so it looks at Col1 and Col5, Col1 will always be the same in the range but the second column selected could be any column, im using this to create...

Hey All, Has anyone got some code for creating a pivot table (as a stored procedure) in Oracle?. Cheers Ben http://www.pubs-uk.com

Hey All, Has anyone got some code for creating a pivot table (as a stored procedure) in Oracle?. Cheers Ben http://www.pubs-uk.com

Hey All, Has anyone got some code for creating a pivot table (as a stored procedure) in Oracle?. Cheers Ben http://www.pubs-uk.com

Thanks Guy, yes i agree tried using ado events, but as scorpio said this event is only kicked off if the connection is explicitly closed, sigh!!, i also was thinking along the lines of polling for a connection, but was hoping there was a easier why of handling it Cheers n beers Ben

Is there event or something that will detect a loss of connection in ADO, eg you are access a db which the network goes down, ADO has still got a connection state of 1, any ideas??? Cheers Ben

The actual query does have set column names, but thats doesnt solve my problem :(

Hi All, Im trying to create a Union All in SQL Server but not having much luck, this is basically what im trying todo. create view aview as (Select * from tblA) Union ALl (Select * from tblb) Union ALl (Select * from tblc) Union ALl (Select * from tbld) all the tables are identical, so its...

Hi All, Im trying to create a bit of Dynamic SQL in a Sybase stored procedure, im used to MS SQL Server so im not sure what im doing wrong in Sybase. Heres my bit of code declare @sql varchar(100) declare @sql2 varchar(100) Select @sql =...