Search results for query: *

Hi, I have a query which returns me some data like: ID StringData --------------------------- 0 11000111000010000111110101010001 1 01110001010101111000010101000111 How can I convert the StringData (which is actually binary only represented by String ones and zeros) into a...

Hi. Thanks for that - I looked at the CASE function and have also come up with the following: SELECT ID, 'Tbl1_Fld1'= CASE WHEN Tbl1.Field1 <> '' THEN '1' ELSE '0' 'Tbl1_Fld2'= CASE WHEN Tbl1.Field2 <> '' THEN '1' ELSE '0' 'Tbl2_Fld1'= CASE WHEN Tbl2.Field1 <> '' THEN '1' ELSE '0' END, FROM...

Hi. I've got a little head scratcher here which i'm hoping someone can help with. I have a table with several fields in it which cater for 60'000 records or so. The table is like this: ID Field1 Field2 ---------------------------- 0 'SomeText' 'SomeText' 1 ''...

Hi, Thanks for the reply. I think i need to correct the diagram a little. This is what i'm looking to do: Application // || \\ Data DLL Forms and logic DLL(1) Forms and logic DLL(2) // SQL DB rather than...

Hi. Im trying to create a application to connect to an SQL databse using ADO (so record locking can be achieved). This in itself is no problem except that I want the data connection and recordsets etc to be in a dll, and the code that uses it (including forms etc) to be another dll...

Hi, Not sure how to convert it back into a sensible date time, but datetime.now.ticks shows the number of milliseconds (100 nanosecond) intervals that have elapsed since 12:00 A.M., January 1, 0001. I'm sure someone here can tell you how to convert it back to a date time - in fact the app...

Hi I've found a solution to the problem, not ideal but it works perfectly. I managed to work out how to call another program and read the output from it, and so can use the normal "ping" command. Public Function PingIPAddress(ByVal Destination As String) As Boolean Dim PingInfo...

Hi all. I'm currently working on an app that requires the need to ping pc's to check that they are online. The app could pottentially have to check several hundred PC's, and so I've made it a multithreaded application. The problem I'm having is that the code that microsoft suggests for...

Ah - My fault! (doh!) I mistook the "reference &= "interfaces.dll"" line and didnt read it properly - sorry! (note to self - read information properly in future :) ) Thanks!

mmmm, That kind of works, but it means that I have to compile everything into a dll file, which would kind of negate the my main point. I really want the data held in a database, mainly so that an end user could add new items if they wanted to (and knew about wmi). I'm sure there must be a...

...objWMI = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") colCurrentClass = objWMI.ExecQuery("Select * from Win32_CDROMDrive") For Each objCurrentClass In colCurrentClass TextBox1.Text = TextBox1.Text & vbCrLf & "CDROM:" & vbCrLf TextBox1.Text =...

Just thought I had better say what the problem was in the end since I've now fixed it. It appears to be a bug in crystal. I found that if I created a "virtual table" (create a command that just returns the table), and then used this for the second reference it works fine! Cheers for all the...

Just tried this and I get the following results. With arrow going from tblAssetHistory to tblLocations_1 (alias) I get a "Query engine error" when I run the report. If I reverse the link, the report runs but doesnt have any data in it. Any other ideas?

Hi, OK, I think I've made a little progress. I can now get 99% of the report to work. The one bit I still cant get to work, is to display the location details (from tblLocations) for the location reported in tblAssetHistory.

Hi, I’m currently trying to develop a report using the version of crystal that comes with .Net 2003 (crystal 9?) and I am having some major problems getting the data displayed. I basically have three tables, one which holds details on Assets (e.g. a monitor) and there locations, one which...

That works a treat - thanks!

Hi, Does anyone know how I can place an image from an imagelist into a statusbar panel? I stuppidly assumed it was as simple as: Me.Statusbar.Icon = Me.Imagelist.Images(0) but it doesnt work, it gives me an error stating that it cant convert the types. Any help would be appreciated. Thanks.

...I've changed the formula to this: ({TblAssets.Desc1} = "rexel" or {TblAssets.Desc1} = "hp") and (if {?Site} = "" then {TblLocations.Level5} like "*" else {TblLocations.Level5}={?Site}) This seems to work, and will only give me exact matches, rather than anyhting that might only partially...

...However, if I pass 'Newcastle ' (trailing space), this doesn't work - even though the entry in the SQL table definatly has a trailing space in there. If I pass ?Site as 'New*' then it works fine as well. Any ideas as this is driving me crazy trying to work out what is happening. Cheers Jeff.

I have just found the answer to my own question after playing around abit. I needed to add: discreteVal = New CrystalDecisions.Shared.ParameterDiscreteValue and all works fine now.