|
Hi,
I don't know the details of DB2, however for any database it all depends on the type of the ITEM_NBR field.
if it is a string with a fixed number of digits, you need string compares, something like
... WHERE ITEM_NBR LIKE "0001%"
if it is an integer number, you can use integer compares, something like
... WHERE ITEM_NBR BETWEEN 00010000000 AND 0001999999"
assuming that is supported, or else
... WHERE ITEM_NBR >= 00010000000 AND ITEM_NBR <= 0001999999"
the string operations will be slower than the numeric operations, and if you need to include a conversion function in your SQL, it will be even slower.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. [The QA section does it automatically now, I hope we soon get it on regular forums as well]
|
|
|
|
|
Thanks for the reply.
Will try it and get back.
|
|
|
|
|
Hi folks
I've searched high and low can anyone inform me if sql server express 2008 is compatible with visual studio 2005 professional? Thanking you x
Kris MCP
|
|
|
|
|
yes, i see no reason why it shouldn't be.
|
|
|
|
|
Haven't tested it but I don't see any reason why it wouldn't work.
|
|
|
|
|
thank you I'll give it a go xx
Kris MCP
|
|
|
|
|
Hi,
could anyone give me a hint for reading the correct size of a apic frame (V2.3). For Text Frames the Frame header gives the correct size. For APIC frames not (seems to be the half of the correct size).
Any idea?
|
|
|
|
|
According to the specification here;
http://www.id3.org/id3v2.3.0#head-70a65d30522ef0d37642224c2a40517ae35b7155[^]
There is nothing that defines what the image size is (except when using a 32x32 PNG icon type $01), so I would imagine you would read the binary data into a buffer, and then check the data against known headers for standard image types.
I have never tried this before so I may be miles of the correct answer.
Have you tried just creating an image object and then pass in the buffer, and see what happens?
You may also want to look at the libraries available here; http://www.id3.org/Implementations[^] to get some info.
|
|
|
|
|
Hi,
the Frame Header is holding the size information of the Frame Data. I'm reading the size and if it's a TextFrame (f.e.) the size information is correct. If I read the size of the APIC Header the size is not correct. As I said it seems to be the half of the image data size.
Michael
|
|
|
|
|
Sorry, i thought you were refering to image sizes and not frame size!
If you look at the specification http://www.id3.org/id3v2.3.0#sec3.3.1[^] it states that the frame size also contains 2 flag values, which tell you if the data is compressed etc. Has this anything to do with it or are you reading these thinking they relate to size of the data?
|
|
|
|
|
Hi,
I solved my problem, it's bettwen my ears!
I used the same procedure for calculating the ID3v2.3 size and the individual frame size.
But the ID3v2.3 size is 4 bytes (0xxx xxxx) and the frame size is a simple 32 Bit Integer 4 Bytes !!!
Ah!
I changed the code and it works!
Thanks for helping me!
Michael
|
|
|
|
|
Glad you fixed your problem!
Just watch out if you move to ID3V2.4 looks like there are some other changes there waiting to catch you out!
|
|
|
|
|
Thanks in Advance
Does some one has worked on L1 Identity Solutions " Bioscrypt Vstation" its a biometric Fingerprint Card Reader device.
The problem i am facing is they gave API to integrate the Machine with my Software but in that SDK , their is no option to specify that which machine you want to Read/Access for downloading the data , I am using TCP/IP protocols
for example this API BII_Close_TCPIP_Communications will close the connection but where or how can i specify the Machine that i want to close Machine A connection or machine B connection.
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
modified on Wednesday, January 27, 2010 3:23 AM
|
|
|
|
|
Well, here is what i just did;
Opened Google and searched for Bioscrypt Vstration
It gave me the companies website; in their Search box i put BII_Close_TCPIP_Communications
and it gave me a PDF with some release notes; in the PDF there was some DLL command references;
BII_VS_Get_IP_Address: Retrieves the IP address stored to the CM’s flash.
• BII_VS_Set_IP_Address: Sets the assigned IP address stored to the CM’s flash.
• BII_VS_Get_DHCP_Mode: Retrieves whether or not DHCP is on or off.
• BII_VS_Set_DHCP_Mode: Enables or Disables DHCP.
• BII_VS_Get_Current_IP_Address: Retrieves the Active IP Address.
• BII_Initialize_Socket_Communications: Performs required initialization for TCPIP communications.
• BII_Open_TCPIP_Communications: Establishes a communication path with a V-Station.
• BII_Close_TCPIP_Communications: Closes the communication path with a V-Station
• BII_Cleanup_Socket_Communications: Closes out and cleans up resources that were consumed in BII_Initialize_Socket_Communications.
• BII_Get_Current_TCP_Port: Returns a value indicating what port the DLL is assuming for V-Station Ethernet communication.
• BII_Get_Current_Host_Name: Returns the host name.
• BII_Is_Using_TCPIP: Returns a value indicating whether or not the DLL is currently assuming TCPIP for communication with a V-Station.
• BII_Get_Socket_Buffer_Size: Returns the size of the Buffer being using by the TCP or UDP Socket.
• BII_Set_Socket_Buffer_Size: Specifies the size of the buffer to be used by the TCP or UDP socket.
• BII_Get_Local_IP_Address: Returns the IP address of the PC for which the DLL is being called from.
• BII_Get_Subnet_Mask: Returns the value of the subnet mask the DLL is using during Ethernet communication.
• BII_Set_Subnet_Mask: Specifies the value for the subnet mask the DLL will use during Ethernet communication.
• BII_Set_Window_Handle: Sets the Windows handle of the calling window needed to establish socket communication.
Now you can maybe look these up in your SDK to find the information!
|
|
|
|
|
Thanks for the Replay
Yes i have the API's but whenever i call API it does not return true , its not even Establishing Connection.Its my 5 machine Brand but is worst ever not a good interface provided.
BII_Read_Transaction_Log (0x0741)
int BII_Read_Transaction_Log (int option, int updateFlag, int maxEntries, unsigned char *log)
*log A pointer to a buffer to hold the Transaction Log data.
Do you know what *log is
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Sorry, i cannot help any more, don't use it or have any knowledge on the product. its maybe time to email their support!
It looks like *log is just as it says a pointer to a buffer of data. So you probable need to create a variable to pass into the function which will then get populated with the data.
|
|
|
|
|
Thanks for replying , i emailed them twice in last 4 days but no response , their support is veryyyyyyy
bad , anyhow thanks again 
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
modified on Wednesday, January 27, 2010 3:24 AM
|
|
|
|
|
Your best source of information is going to be the company that wrote the API. It is extremely unlikely you're ever going to find someone on these forums that has used that library.
|
|
|
|
|
Yes , you are right , contacted them twice but all in vain. 
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Hi All
I am using an login window for my apllication.
The application needs to find the username of the currently loggin system .
is it possible to retrieve the information...Kindly help me..I m using VB6
Thanks
|
|
|
|
|
If you are building a logon screen that implies you are STARTING a development, logon being one of the first things you need.
If this is so then STOP - you are using a platform that is no longer supported and should be allowed to drift into history. Download the .Net versions and start using that technology, you will find lots of support and help for the .Net version and they are FREE.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hellogany wrote: is it possible to retrieve the information...
Yup, example can be found here[^].
I are Troll 
|
|
|
|
|
I am using VBA (Access 2007) for my project. On the form load, listview retrieves data from the db but gets problem (Error Message : Type mismatch).
Here is my code.
Dim Rst As New ADODB.Recordset
Dim Str As String
Rst.CursorLocation = adUseClient
Str = "Select * From qry_staff_info Order By sID"
Rst.Open Str, Application.CodeProject.Connection, adOpenDynamic
If Rst.RecordCount < 0 Then Exit Sub
If Rst.RecordCount > 0 Then
Do While Not Rst.EOF
Dim lvwItem As ListItem
Set lvwItem = Me.lvwStaff.ListItems.Add(, , Rst![insurno]) ''''''' This the line which debug and show the error message (Type mismatch)
lvwItem.SubItems(1) = Rst![sname]
lvwItem.SubItems(2) = Rst![bgroup]
lvwItem.SubItems(3) = Rst![gender]
lvwItem.SubItems(4) = Rst![dob]
lvwItem.SubItems(5) = Rst![doj]
lvwItem.SubItems(6) = Rst![Position]
lvwItem.SubItems(7) = Rst![location]
lvwItem.SubItems(8) = Rst![Address]
lvwItem.SubItems(9) = Rst![Telephone]
lvwItem.SubItems(10) = Rst![martialstatus]
lvwItem.SubItems(11) = Rst![nod]
Loop
End If
Thanks,
Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner
|
|
|
|
|
misCafe wrote: (Error Message : Type mismatch)
Could that be caused by insurno being a number? Try converting it explicitly;
Set lvwItem = Me.lvwStaff.ListItems.Add(, , CStr(Rst![insurno]))
I are Troll
|
|
|
|
|
Thanks so much for your help. The problem is fixed. 
Anyways, I want to click on the ListView Item and load its values from each colums to the TextBox, ComboBox. It is the better way to update the record.
Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
