|
I have a table with 2 fields: ProductCode(Text) and InventoryNo(Int). I'd like to display the largest integer in InventoryNo field that has the same ProductCode. my SQL query is :
SELECT MAX(InventoryNo) FROM StockTable WHERE ProductCode = '&txtprdcode.Text&'
The problem is, the outcome I got was the largest integer regardless of its ProductCode (The output was more like the largest integer in InventoryNo Column).
What seems to be the problem?
TQ
|
|
|
|
|
SELECT MAX(InventoryNo) FROM StockTable WHERE ProductCode = & "'"&txtprdcode.Text&"'"
if InventoryNo = ProductCode then
'some code
else
'mismatch
endif
Hope this helps,
-- modified at 10:53 Friday 16th December, 2005
|
|
|
|
|
We're needing to embed into a program - a piece that will force the user to log in again - this is necessary for FDA Part 11 - and then have the app verify the credentials which were just entered against the active directory. Unfortunately the app we have isn't er/esig capable - so we're having to customize it - but so far, haven't found anything we could use and not have to write from scratch...
anybody know of anything useable?
|
|
|
|
|
I have to write app's that are 21 CFR part 11 compliant too.
(To everyone else, CFR stands for Compliance to Federal Regulations.)
I don't think Windows does enough to satisfy this. I (and my competitors) typically have to create apps having their own user accounts and login handling in order to satisfy the FDA's requirments. Requirements such as password aging, auto-logout, user authentication, and audit trails. Windows won't do those last 2 bits for you.
|
|
|
|
|
Hi all,
Can someone tell me how to use USB port for communication in VB?
Thanks in advance,
sushma
|
|
|
|
|
That depends entirely on the device you want to talk to. There is no such thing as "generic" code that lets you talk to any device on USB. Most of teh time, this will require lower level calls to the devices drivers.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanx so much for responding to my post.I must establish communication between two PCs through USB port.I have no idea of how to go about it.Please tell me what are the pre-requisits for programming a USB port.
Thanx again,
sushma
|
|
|
|
|
First, you need a special USB host-to-host cable to connect them. Using any old USB cable you get for connecting devices to the PC can blow the ports on both PC's. After that, you install the drivers and end up with a 2 machine network that works over TCP/IP. There's nothing you do in your source code to specially handle USB networks. To your code, it looks just like any other TCP/IP network.
USB PC to PC Network Cable TCP/IP[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 7:48 Monday 19th December, 2005
|
|
|
|
|
Hi Dave,
I got few modules(hidinterface,osinterface,USBmAPI) and DLLs(USBm.dll,APIGID32.DLL).I got these from intel site(u may be knowing about these). Cant i work on my program using these?
|
|
|
|
|
Why? So you can take 10 times longer to write your app? Do you have any idea how USB works? How to enumerate devices on the bus, select a device, communicate with another host on the bus? This is very specialized stuff and there is not alot of documentation out there on how to do it. You won't find any code in VB.NET that show you how to do this.
You're re-inventing the wheel when you don't have to...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks so much for ur suggestion.Please tell me which driver software i must install?What is the cost of the driver software?What are the necessary steps to be followed after installing that?.I have worked on RS232 serial communication using MScomm activex control in VB.I just want to know whether i will be able to implement the same with USB? Will the driver software be flexible like an activex control?. Initially i will be working on PC to PC communication.Later on i must write program for establishing communication between PC and Hand Held Controller.Please do help me with this, i will be very greatful to u.
Thanx again,
Sushma
|
|
|
|
|
Sushmadm wrote: Please tell me which driver software i must install?
Usually comes with the cable you need...
Sushmadm wrote: What is the cost of the driver software?
Comes with the cable!
Sushmadm wrote: What are the necessary steps to be followed after installing that?
Read the documentation that comes with the cable!
Sushmadm wrote: I have worked on RS232 serial communication using MScomm activex control in VB.I just want to know whether i will be able to implement the same with USB?
No. Like I said before, it works just like any other TCP/IP network. Your Serial Comm experience won't help you.
Sushmadm wrote: Will the driver software be flexible like an activex control?.
How should I know? I've never done this before. The information you're getting is from the small amount of YOUR homework I've done!
Sushmadm wrote: Hand Held Controller.Please do help me with this,
Like I said, no experience with it. This part will depend HEAVILY on your device and your application on it.
Look, you're going to have to do your own homework on this. What your doing is rarely done and adding a "handheld device" to this will further restrict the help you get from anyone because of the VERY specialized nature of what your trying to do.
If you don't already understand TCP/IP networking, if your device and application even support this, start picking up some books on it. You're most definately going to need them.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks so much for ur suggestion.It will be of great help to me.
Thanx again,
Sushma
|
|
|
|
|
Hi Dave,
Thanks so much for all ur suggestions. I have baught a USB cable which comes along with a driver.The driver after installed creates a COM port for USB port as soon as the USB cable is plugged in.Hence i can access the USB port just like a com port. It made my job very easy!
Thanx again,
Sushma
|
|
|
|
|
want code for sending SMS from PC to mobile phone...
help me..
Regords,
Rajkumar
|
|
|
|
|
Its not that simple. You will need an account with an sms portal service. They will normally have examples and api's to enable you to do this. Your best bet is to google for some probably in the country you ware wanting to service.
Jonathan
|
|
|
|
|
I'm having trouble finding a way to selecting a control and drag it to another location on the form when the program is running (not the design mode). Same thing is true for resizing a control with the mouse during runtime.
I could do this in VB6 but the method to do it in VB 2005 seems to elude me and I haven't been able to find any references on how to do this.
I would appreciate any help on this.
|
|
|
|
|
I am new to Nhibernate. I need to change my asp.net project to incorporate Nhibernate instead of ADO.net.
I am unable to replace the SqlAdapter and the dataset code.
The code is --:
da = New SqlDataAdapter("select * from DBR where 0=1", MyConn)
Cb = New SqlCommandBuilder(da)
da = Cb.DataAdapter
da.Fill(ds, "DBR")
ds = Dtset.IterateThroughChildren(parent, ds)
da.Update(ds, "DBR")
I have the class for DBR table, but can any one tell tell how to do bulk updates or replace the above code to nhibernate code.
Gaurav Rahi
-- modified at 0:51 Friday 16th December, 2005
|
|
|
|
|
You'd probably get a better response by posting your question on the Nhibernate SourceForge board. There a literly thousands of libraries and controls out there. The chances that someone who has used Nhibernate will see your post here are very, very slim.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i am the new one in programming for pocket pc, so now we need to create the kiosk mode the pocket pc, so how?
go ahead...do best on my works....
|
|
|
|
|
i would like to rewrite the program for pocket pc, now the first problem is that i want to disable the start menu(which the pocket pc2002 emulator system installed in visual stadio.net 2003,), i want to be like this, when the user swiched on the pocket pc, can only got the log-in page,but now, when i test my appliction on the ppc emulator,yes, firstly can have the log-in page,but when i exit this application, can still got the start menu, i want to disable it,so how?
go ahead...do best on my works....
|
|
|
|
|
You'll probably get a better response in the Embedded/Mobile Forum[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am using print dialog in my project, I want to use "the select pages FROM PAGE TO PAGE properties.
printdialog1.allowssomepages = true ' i have activated but I am not able to print only the no of pages instead its printing all pages.
thanks in advance
|
|
|
|
|
check this article
http://www.startvbdotnet.com/controls/printdialog1.aspx
|
|
|
|
|
thanks for that suggestion, it helped to know more about printing.
But it doesnot say anything about how to use no of pages selection (ie. FROM PAGE, TO PAGE) . I have enabled the print dialog and also the selection but was not able to print the specified pages even if i told to print (EXAMPLE FROM PAGE 1 : TO 2 PAGE), instead its prints all.
Thanks again
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
