38 Solved Topics
Remove Filter  | |
| | Hi all, I've been having a problem adding a record to an Access database using datasets and da.update etc. I'm trying to create a simple program that displays the records of a database table in a series of text boxes. I've managed to get my next and previous buttons working … |
 | Hi Dw I want to record video with audio, the current program has two forms of which one form record external video and the other form record internal so I've reduced the size of an external video capture to lower right hand corner of my screen and set it to … |
| | Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … |
 | Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same … |
| | Hello. I am a complete newbit to Python. I am trying to read a text file (which is actually an svg file) and add a line to the text file. I would also like to remove certain text from the file. I am trying to edit some of the tags … |
 | Hi, I'm new to vb and I need to record the time the user used a certain privilege and the time s/he finished using it. i used date/time picker but whenever i run the program, i can't edit the time. only the date. help please? |
| | Can someone help me on my database with regards that the records can be prone to data redundancy.. pls help to avoid record redundancy on my database.... How do I check if the record that i will be input is existing on my database.. and i want to prompt the … |
| | Friends please help me... I have Three text boxes 1.Bank 2.Acno 3.Name I am selecting record from database where Bank and Acno are =(txtbank.text and txtacno.text) If any record found, the focus should go to the third textbox-'Name' else message "Record not found" should be displayed.I tried the following code … |
| | I have a MSHFlexGird (fgdCompany) and a search command. When the user enters the search data into "txtSearch", the command should search for the data and show it to the user by : Highlighting the record in the MSHFlexGrid -OR- By bringing the row that contains the searched data to … |
| | Hey guys i am having a problem with displaying a single record out of a text file the code is not reaching the "if" function in the while loop of the "getRecord" Function please help. Everything else is working import java.io.*; import java.util.Scanner; import java.util.InputMismatchException; public class FileTest { //Globals … |
| | table slabpay ------------------------------------------------------- agent_id|agent_name|cust_id|cust_name|installment_amt| ------------------------------------------------------- 1 |mike |1 |john |350 | ------------------------------------------------------- 1 |mike |1 |john |400 | ------------------------------------------------------ 1 |mike |2 |abraham |350 | ------------------------------------------------------- 1 |mike |1 |john |450 | ------------------------------------------------------- 1 |mike |2 |abraham |400 | ------------------------------------------------------- mysql query ------------------------------------------------------ `$select = mysql_query("SELECT cust_id, cust_name,installment_amt FROM slabpay … |
 | hi, i am new to mysql and also to php, i am trying to add a feature to a webpage, for showing some latest records from a mysql databse. i managed to show records from mysql database, but the problem is i only trying to show the first four records … |
 | Hi, I am trying to learn how to use a data base to store photos and such, I can now get info into the base and can get all the records to display , this is not what I had planed, So that lead me on a surch for answers … |
| | Hi all, I was having a huge problem,i mean i spent days trying to fix it but i get the same exception everytime when i run the app. here's the thing i have a record that is loaded from the database using the listview.it works perfect for the insertion part.but …  |
| | Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to … |
| | For reason I won't bore you with, I need to update an archive database periodically with typically blocks of 100-300 records. Each record has 6 visible fields in the database. Frequently 4 of the 6 fields have the same information in them for the whole block of data. For a … |
| | Hello everyone. I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list: record1. Last Name, First Name, phone, email record2. Last Name, First Name, phone, email etc... What I want to … |
| | I assume this is simple enough, when you know how :) I retrieve 2 files, pricelist with multiple information such as number, price, desciption and so on, the 2. file is discount file, with 2 fields : discountcode;discount like G30;48 which means discountcode = G30 which equals 48% I have … |
 | Hello, I want to submit multiple records into a mysql database, and I have hit a snag. I am developing a web application that displays student records, and upon displaying student records per class, I want to be able to add marks for beginning of term, mid term and end … |
 | //When i click the update button to update record in database,i get following error : " String or binary data would be truncated. The statement has been terminated." plz help me to solve this problem using System; using System.Collections; using System.Configuration; using System.Web.Configuration; using System.Data; using System.Linq; using System.Web; using … |
| | okay. Here's my problem. I have a form in which a Microsoft Hierarchical Flex Gid (fgdCompany) is used to display records taken from a database to relavent textboxes on the same form. When a record from fgdCompany is clicked, then the data in that record is shown on the textboxes. …  |
| | Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely … |
 | Sorry I'm new to these stuff but I am having a hard time about this. So I'll trying to create a php and mysql program which can view records from database server. In my form I have 2 dropdown list and 2 submit button, the first one the the list … |
| | Hi I am trying to display the records Horizontally from my 3 different table 1. place table - n number of place 2. Item name 3. Item in different place i want to display the above report as in the attachment. please help me to resolve the issue [CODE]<table width="100%" … |
 | Hello everybody. I've created a PHP page that adds a new record to a table. I want to know what's the ID of that created record in that table. For example: [CODE]mysql_query("insert into tableName(field_A,field_B) values('valueA','valueB')");[/CODE] |
 | Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone … |
| | Hi guys, Is there a difference between these two: struct->variable struct.variable ? |
 | good, i am having trouble on how to insert record date in my access db. i am using hdate as my field and his data type is short date here is my code [CODE] cmd.CommandText = "INSERT INTO hold ([hdate], des) VALUES (#" & myDate & "#, '" & TextBox1.Text …  |
| | hello everyone, got issue regarding reading duplicate records in a text file... i need to read the file and look for any duplicates data/keys in the text file and write them to another file (all the duplicates records)... how can i do that, in looping...:-/ any help...:) thanks! |
| | when i try to add a record [CODE]Private Sub cmdDone_Click() Dim Rs As New ADODB.Recordset Set Rs = New ADODB.Recordset Call ServerConnect Rs.Open "SELECT * FROM list1", conn, adOpenStatic, adLockOptimistic Rs.AddNew Rs!CustomerName = txtName.Text Rs!ContactNumber = txtContact.Text Rs!Date = dt.Value Rs!TimeStart = cmbStart.Text Rs!TimeEnd = cmbEnd.Text Rs!Event = cmbEvent.Text Rs!Guest … |
The End.