Обсуждение: "Field is too small"
I am getting a "field is too small" error in an Access DB running over ODBC. The field in question is varchar(32). Here is the weird thing: I am inserting into a table with a rule that sends the result to a different table. However, when I insert into the table without a rule, it works fine. It also works fine both ways from psql and isql at the command line (why oh why am I messing around with stupid Microsoft products?!) This is also NOT a problem with booleans--neither of the fields are boolean. Let me know how I might be able to help. I have logs from my local machine and I could get logs from the server. Should I just use Triggers... Thanks W __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
Webb Sprague wrote:
>
> I am getting a "field is too small" error in an Access
> DB running over ODBC. The field in question is
> varchar(32).
>
> Here is the weird thing: I am inserting into a table
> with a rule that sends the result to a different
> table.
Are you using a DO INSTEAD rule ?
Could you send me the Mylog output ?
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
Hi all,
I would like to do a pass through query in a form as
part of a button-click event. I just want to fire off
a PL/PGSQL function on the Postgres server.
Is this possible? Is it easy? I just want to insert
it below where the comment says:
Private Sub foobar_Click()
On Error GoTo Err_foobar_Click
'FIRE OFF SERVER FUNCTION HERE
'SELECT server_func()
DoCmd.GoToRecord , , acNewRec
Exit_foobar_Click:
Exit Sub
Err_foobar_Click:
MsgBox Err.Description
Resume Exit_foobar_Click
End Sub
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Hi. Yes, I do still lurk here. Yes, it is possible to do what you want. Have a look in the list archives at some of my ODBC VB function stuff. It has to do with using passthrough queries for the datasource of list and combo boxes (maybe you wanted this??). You'll see how I did it in there and it should help you out. One thin you'll want to change is a parameter that means "query does not return a data set". I won't tell you details here because I probably don't remember them correctly. If you want an answer right now then go search, or else maybe someone else will reply too. The 'Building Applications with MS Access' book is of value too. -Cedar On Fri, 28 Jun 2002, Webb Sprague wrote: > Hi all, > > I would like to do a pass through query in a form as > part of a button-click event. I just want to fire off > a PL/PGSQL function on the Postgres server. > > Is this possible? Is it easy? I just want to insert > it below where the comment says: > > Private Sub foobar_Click() > On Error GoTo Err_foobar_Click > > 'FIRE OFF SERVER FUNCTION HERE > 'SELECT server_func() > > DoCmd.GoToRecord , , acNewRec > > Exit_foobar_Click: > Exit Sub > > Err_foobar_Click: > MsgBox Err.Description > Resume Exit_foobar_Click > > End Sub > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > >
Hi Cedar, I have searched google postgres.odbc for your name, and I can't find anything that works (I just want to cut and paste something in). Can you or anyone else point me to an example or a tutorial? Thx W --- Cedar Cox <cedarc@visionforisrael.com> wrote: > > Hi. Yes, I do still lurk here. Yes, it is possible > to do what you > want. Have a look in the list archives at some of > my ODBC VB > function stuff. It has to do with using passthrough > queries for the > datasource of list and combo boxes (maybe you wanted > this??). > You'll see how I did it in there and it should help > you out. One > thin you'll want to change is a parameter that means > "query does not > return a data set". I won't tell you details here > because I > probably don't remember them correctly. If you want > an answer > right now then go search, or else maybe someone else > will reply > too. The 'Building Applications with MS Access' > book is of > value too. > > -Cedar > > On Fri, 28 Jun 2002, Webb Sprague wrote: > > > Hi all, > > > > I would like to do a pass through query in a form > as > > part of a button-click event. I just want to fire > off > > a PL/PGSQL function on the Postgres server. > > > > Is this possible? Is it easy? I just want to > insert > > it below where the comment says: > > > > Private Sub foobar_Click() > > On Error GoTo Err_foobar_Click > > > > 'FIRE OFF SERVER FUNCTION HERE > > 'SELECT server_func() > > > > DoCmd.GoToRecord , , acNewRec > > > > Exit_foobar_Click: > > Exit Sub > > > > Err_foobar_Click: > > MsgBox Err.Description > > Resume Exit_foobar_Click > > > > End Sub > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > > > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
Webb Sprague wrote:
>
>
> Now Access will allow me to start adding records, but
> I get the "field too small error".
>
> Attached are the two log files.
>
> I saw your earlier post for when someone was trying to
> write to a view and you gave a patch. I wonder if
> this may apply here.
Judging from the log you sent me, probably
the patch would fix your problem.
> I am not root on the machine so
> I can't try it, but on Monday the machine owner will
> be back and we can try it then.
Please let me know the result.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/