[R-sig-DB] using the field.types arg in dbBuildTableDefinition()

[Prasenjit Kapat]

Hi,

Fwd-ing to the appropriate list. The thread being referred to by Gipsi
is the following:
https://stat.ethz.ch/pipermail/r-sig-db/2008q4/000511.html

On Tue, Sep 21, 2010 at 10:28 AM, Gipsi Lima-Mendez
<gipsi.lima using vub.ac.be> wrote:
> Hi,
>
> I want to define the field types for a mysql table and found nothing but
> this old post of yours (see below). I am not use to named.lists, so it does
> not help me.
>
> If the table I want to create has columns named "ColumnA" and "ColumnB",
> would this named list be something like: field.types =
> list(ColumnA="TEXT",ColumnB="VARCHAR")?

That would be the case, although I am not sure if it will work with
the mysql DB.

> Thanks in advance,
> regards,
>
> G

G:
Please address / reply-to the list. You'll have a better chance of a
proper solution.

>
> Ignore my earlier mail on this subject. Sorry for spamming.
>
> On Thu, Nov 6, 2008 at 6:59 PM, Prasenjit Kapat <kapatp at gmail.com> wrote:
>> Getting back, ?dbBuildTableDefinition shows the following:
>>
>> field.types   optional named list of the types for each field in obj
>>
>> Am I interpreting it wrongly?
>
> Yes I did! It is a "named-list" and not a character vector :((
>
>
> Gipsi Lima Mendez, PhD
> Bioinformatics and (eco-)systems biology
> Department of Molecular and Cellular Interactions
> VIB - Vrije Universiteit Brussel
> Pleinlaan 2
> 1050 Brussels, Belgium


-- 
Prasenjit