I'm having difficulty with trying to update a Access memo field through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"
Any help would be greatly apprciated.
6  2710 
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.
Greetings,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET
I'm having difficulty with trying to update a Access memo field through
an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"
Any help would be greatly apprciated.
Unfortunately, I want to be able to use an Access database at this point. I
looked through the comparisons and see how it could work with SQL Server.
But, I still haven't found a solution for Access.
"Patrick Olurotimi Ige" wrote: Hi Matt,
Try going through this at:-
http://office.microsoft.com/en-us/as...745731033.aspx
** Is it possible do change ur DB to SQL SERVER?
Hope it helps
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would be
greatly appreciated.
Thanks in advance,
Matt
"Wessel Troost" wrote: Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.
Greetings,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET
I'm having difficulty with trying to update a Access memo field through
an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"
Any help would be greatly apprciated.
Matt,
Sorry, I'm too busy right now to write an example. However, basically
it's something like this:
- Add a reference to the COM object "Micrsoft ActiveX Data Objects"
- Create an ADODB connection object with the right connection string
(examples can be found through google)
- Recordset = Connection->Open("tablenam e")
- Find the right record
- Update the memofield like: RecordSet("MyFi eld") = "Long text"
I'm not sure that this would even work, but it's the road I would try...
Regards,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 2:55 PM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Re: Update Access Memo field from ASP.NET
I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would
be
greatly appreciated.
Thanks in advance,
Matt
"Wessel Troost" wrote: Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.
Greetings,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET
I'm having difficulty with trying to update a Access memo field
through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary,
Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"
Any help would be greatly apprciated.
Thanks for the help. I'll give it a try.
"Wessel Troost" wrote: Matt,
Sorry, I'm too busy right now to write an example. However, basically
it's something like this:
- Add a reference to the COM object "Micrsoft ActiveX Data Objects"
- Create an ADODB connection object with the right connection string
(examples can be found through google)
- Recordset = Connection->Open("tablenam e")
- Find the right record
- Update the memofield like: RecordSet("MyFi eld") = "Long text"
I'm not sure that this would even work, but it's the road I would try...
Regards,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 2:55 PM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Re: Update Access Memo field from ASP.NET
I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would
be
greatly appreciated.
Thanks in advance,
Matt
"Wessel Troost" wrote:
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.
Greetings,
Wessel
-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET
I'm having difficulty with trying to update a Access memo field
through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary,
Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"
Any help would be greatly apprciated.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: BlackFireNova |
last post by:
This concerns an Access 2002 (XP) database. There are two fields,
"Notes" (Memo Field) and "Notes Update" on a form (among others)
which I am concerned with here.
Problem: I need to be able to tell when people have added notes to a
record. (this database contains 6000+ records)
I want to set it up so that "Notes Update" is updated to the current
date whenever someone actually enters data into, or modifies data in,
the "Notes"...
|
by: htmlgeek |
last post by:
I've beaten my head againts this for two weeks and would appreciate
any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000
and then 2003 and received same problems!
I've rebuilt pages etc. etc.
Insert and update work, but updating of records with data in the memo
field seem to crash/corrupt Access--but only on those records.
The problem seems to narrow down to updating a record's memo field. It
|
by: Andrew Donnelly |
last post by:
I am trying to update a memo field in a table from a form that I have
created. The form is unbound, and once the user makes their changes,
they have to click the continue button. Once the button is click
then, there is some VB code that uses SQL Update to take the
information on the form and update the table with the new changes.
However, I am having issues with the Memo fields. I have looked at
several different posts and have not been...
|
by: Mark Reed |
last post by:
Hi All,
I'm having a problem with the following code. I've read quite a lot of
old posts regarding the issue but none seem to affer a solution.
The scenario is. I have a bound form which contains a couple of memo fields.
I need to keep some sort of log as to when each update of the memo field
occurs so I have locked bot the memo fields on the main form. To edit them,
the user double clicks the ememo field which then opens an unbound...
|
by: John |
last post by:
Hi
I had a working vs 2003 application with access backend. I added a couple
fields in a table in access db and then to allow user to have access to
these fields via app I did the following;
1. Regenerated the data adapter sqls by running the data adapter wizard and
pasting the resulting code into my app.
2. Deleted the data adapter correspond to the relevant access table from the
| | |
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo field is printed within
the detailed area. The problem is, the apllication is not setup
properly, thus the users are entering data within the memo field as:
location1 1/1/2005 1/1/2006
|
by: Owen Jenkins |
last post by:
Following on from an earlier post...
I can reliably corrupt a record by doing the following ...
Open two separate but identical front ends on one PC each linking to the
same back end.
Edit a records in one front end and leave it unsaved.
Edit the same record in the other front end and save the change.
Save the change in the first front end - this pops up the Write Conflict
message to which I click Save.
|
by: Access Programming only with macros, no code |
last post by:
ERROR MESSAGE:
Could not update; currently locked by another session on this
machine.
BACKGROUND
I have the following objects:
Table1 - HO (which has about 51,000+ records)
Table2 - Contact (which has 68,000+ records)
|
by: thewesties |
last post by:
Could somebody please help me before I dump a gallon of water on my pc!
I am very happy to have come across this site on the internet. TheScripts has helped me through so many issues to this point. I have now spent the last 2 days scouring the net for a resolution to my problem.
I have a DB with MANY tables, but a transfer of 1 memo field between 2 in particular (tbl_Proposal to tbl_Job) is where my problem is. Nothing is working. The...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: 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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
