Apologies for this query for i think it is pretty straightforward .
(VB 6.0)
Through a SQL query i have got a string which needs to be put in a textpad.(form code). Till now i am able to put data in dropdown(list down) boxes but not in textoad. The error its giving is invalid procedure call.
A few code snippets i shall give to make the picture clearer.
sQueryGetReview er = "Select #### from #### where user_id = '" + UserName + "'" ' Get details
--after logging in the Database
rSetReviewer.Op en sQueryGetReview er, strCon, adOpenForwardOn ly, adLockOptimisti c
Text2.Text = rSetReviewer.Ge tString (Text2 is the name of the textfield)
I have also tried rSetReviewer.Fi elds(0) among others.
Also when i tried GetString/Getrows im getting this error..
Either BOF or EOF is true , or the current record has been deleted.Request ed operation requires current record.
Also regarding the populating doprdown list. I am able to get all the values in the list. But is there a way to have a default value shown when the form appears. Right now the field is empy and only when its dropped down then i am able to see the values.
Again this is not high priority in comparison with my earlier query.
Thanks a lot!
4  1774 
The BOF/EOF thing sounds to me as though you just didn't find any records.
Well, executing the query gives me 1 record.
Im putting a messge box after the query -MsgBox (sQueryGetRevie wer) and i get a valid record.
I think there is another way to populate the textfield.
Its done/ - While Not rs####.EOF
-
Text2.Text = (rS####.Fields(0))
-
rS###.MoveNext
-
Wend
Thanks.
Glad to hear it worked out.
(I think you gave us a bum steer with that "MsgBox (sQueryGetRevie wer)", since sQueryGetReview er was just a string.)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Will Pittenger |
last post by:
If I were writing a C++ program, I would write a mouse hook. Does C# and
..NET 1.1 have anything equivalent. If not, I suppose I will need to use the
Win32 API.
----------
Will Pittenger
E-Mail: mailto:will.pittenger@verizon.net
All mail filtered by Qurb (www.qurb.com)
|
by: Brent Burkart |
last post by:
I am trying to capture the Windows Authenticated username, but I want to be
able to capture the login name that exists in IIS, not Windows. In order to
enter my company's intranet through the internet, they have to login. I want
to be able to capture that login versus their Windows login because I need
to know who they are from any computer rather than only their computer. Any
ideas?
Thanks
|
by: Krishna Kumar |
last post by:
Hai all,
I am doing a project in .net and in that project I have a problem in
capturing text from an image. i.e images like CAPTCHA images . which has
inbuilt text with in the image.So, Can any one suggest me how to continue
my work or give their valuable suggestions for capturing text in the
CAPTCHA image .
yours
KrishnaKumar
|
by: GreggTB |
last post by:
I've looked online for a while but haven't found a whole lot of really
good resources for this, so I'm hoping that maybe someone here can
point me in the right direction. I'm working with a 3rd party
application that allows users to create customizable files within
certain syntax rules. There isn't, however, a good editor for these
files (users end up using Notepad, I guess) and I would like to create
one...most likely using Visual Studio....
|
by: Dave White |
last post by:
Hello everyone,
I am considering changing text editors.
Which open source text editor would you recommend for xhtml & css?
Thanks in advance,
Dave White
| | |
by: GS |
last post by:
How can one avoid capturing leading empty or blank lines?
the data I deal with look like this
"will be paid on the dates you specified.
xyz supplier
amount: $100.52 when: September 07, 2007 reference #: 0415
from: operating account
|
by: hsriat |
last post by:
I had been using TextPad (http://www.textpad.com ) to edit HTML, PHP and JS files. Few days ago, it started giving some message while editing
'The file has been changed by some external editor, do you want to reload it?'
First I thought it might be some bug in TextPad, but then I used EmEditor(http://www.emeditor.com) one day. And same message was given by it while working on it.
Now it happens with all the files.
What's this? How my...
|
by: tshad |
last post by:
I have a program in 2005 that is reading a text file removing text and then
writing it back out again. It removes lines that start with PRINT.
This program has worked fine for months. Now all of a sudden, it is reading
a straight text file and adding a null after each character it reads in.
Why is that?
The original file doesn't have nulls in them. The code is:
********************************************
using System;
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
