Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user
Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information.Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the...
Answer Question
| Jul 8 2008 7:04 AM GMT
| asked by
VB RD
PL/SQL, Database programming
Database connectivity with c++
How to connect backend(database to C++(front end) ?
Answer Question
| Jun 26 2008 4:25 AM GMT
| asked by
Mkaaa
C++, Database connectivity, Database programming
storing multiple fields iin jsp into a single column in th table
i have one text filed and a select field.I have to concatenate both of them and store into a single column in the table. how do i achieve this??
View Answer
| Jun 25 2008 9:19 AM GMT
| asked by
Jem
Concatenate, Database programming, JavaServer Pages
Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN...
Answer Question
| Jun 24 2008 10:39 AM GMT
| asked by
Nichalos82
Access, Database, Conditional formatting
DB Web interface
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?
View Answer
| Jun 6 2008 7:26 AM GMT
| asked by
Jaco
Microsoft Access, Database programming, Database frontend
Date Picker
Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?
View Answer
| May 31 2008 2:11 PM GMT
| asked by
Shazzie
Calendar control, Date Picker, Microsoft Access
Numeric Field to be left aligned
I have declared a numeric field with lenth 15,2, the same to be displayed left aligned. By default it is displaying right aligned.
View Answer
| May 27 2008 12:36 AM GMT
| asked by
Red
Database programming
auto send e-mail
How does one auto send e-mail from access
View Answer
| May 22 2008 1:59 PM GMT
| asked by
Mabaxter
Microsoft Access, Database programming
Updating Tables
Hello, I am trying to create a "yes/no" field, that automatically updates when the conditions have been met. Presently, I have two tables that have been created and have a relationship between them. In the first table, is the "master" table. In the "master" table, I have a field called "All...
View Answer
| May 22 2008 1:30 PM GMT
| asked by
Bmoquin
Database programming
replace field with count variable in foxpro
Hello, in Foxpro 6, I need to replace a field with the count from a memory variable when an invoice # is the same. The database lists the detailed line items of the invoice and the invoice # next to them. So, if invoice 56 had two items, I would need 1 in the count column for item 1 and a 2 in the...
View Answer
| May 20 2008 4:49 PM GMT
| asked by
Prep89
SQL, VB, Visual Basic
Aggregate data
Can I manipulate aggregate tables at the census tract level? In essence, could I create dummy variables, such as: white, black, hipanic, other for 100 census tracts? Or is this only possible with individual level data?
View Answer
| May 11 2008 5:42 AM GMT
| asked by
Romanov38
Census Tract data, Database programming, Database
Restricting the user to insert next record
Hai all,I have a subform which is in datasheetview mode , I have to validate the subform field s in such a way that if one of the fields is empty i will popup a msg like 'must enter a value ' then the focus should goto that field and restrict the user to insert next record till the user provides...
View Answer
| Apr 30 2008 10:47 AM GMT
| asked by
Giridharrajup
Form validations, Datasheet View, Database
How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.
How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.
View Answer
| Apr 28 2008 4:33 AM GMT
| asked by
06
ComboBox, ListBox, Development
vb.net connection string for ms sql database for window application
vb.net connection string for ms sql server database in window application
View Answer
| Apr 2 2008 7:55 AM GMT
| asked by
Nikhil21
Visual Basic .NET, VB.NET, SQL Server
Earlier record’s Field in Crystal Record XI
Hi....how r u all ?I having problem with my reports.My record selection is based on the "Date" Date ChildrenName Current Weight Previous Weight 15-02-2008 Hein 15.8 15.0 Adam 14.8 15.2 If i m...
Answer Question
| Mar 17 2008 7:48 AM GMT
| asked by
Poongundran.m
Crystal Reports XI, Database programming
MS Access-Query
I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?
View Answer
| Mar 6 2008 4:54 PM GMT
| asked by
FranktheMan
Access, Database programming, Microsoft Access
