| From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "'futrzak'" <futrzak(at)archie(dot)dhs(dot)org> |
| Cc: | "'pgadmin-hackers(at)postgresql(dot)org'" <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: MS SQL Migration |
| Date: | 2002-01-11 09:51:43 |
| Message-ID: | FED2B709E3270E4B903EB0175A49BCB1047406@dogbert.vale-housing.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
> -----Original Message-----
> From: futrzak [mailto:futrzak(at)archie(dot)dhs(dot)org]
> Sent: 11 January 2002 09:22
> To: Dave Page
> Subject: Re: MS SQL Migration
>
Hi Artur,
Further to my previous email, I've updated the code to:
' AM 20020110
' driver don't returns correct values - setting to default 18,4
If szTemp2 = "numeric" Then
If
catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Type = adNumeric
Then
szTemp2 = szTemp2 & "(" &
catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Precision & ","
& catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).NumericScale &
")"
Else
szTemp2 = szTemp2 & "(" & "18" & "," & "4" & ")"
End If
End If
Does that look good to you?
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | futrzak | 2002-01-11 09:54:34 | Re: MS SQL Migration |
| Previous Message | Dave Page | 2002-01-11 09:44:22 | Re: MS SQL Migration |