|
What are you calling a "DBF" file? Which database engine does it use?
There is no code you put in your application to index a database. All indexing is done by the database engine. What you do there depends on the engine and the design of your database.
|
|
|
|
|
Thanks for ur reply.
I use db2K database.
I have more than 110000 lines in each table.
I want to keep a check for a range of values.
Thant is:
the vales in the table need a search in the first column(ITEM_NBR) of the table(E_Ensemb)
it has values starting from 0001000000 and so on.
I need to set a range/index to search, saying that if a number starts with 0001 search in 00010000000 - 0001999999
if starts with 0002 then search in 0002000000 - 0002999999.
Thanks in advance
|
|
|
|
|
OK, this sounds like an index is required on the database. I don't know DB2 at all so I can't tell you how to do it. But, I'm sure the documentation on DB2's SQL engine would spell that out pretty clearly.
|
|
|
|
|
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
|
|
|
|